DROP TABLE Statement

Deletes an existing table.

 

Syntax

 

DROP TABLE table

 

The DROP TABLE statement has these parts:

 

Part

Description

table

The name of the table to be deleted.

 

Remarks

 

We can use CREATE TABLE to create a table and ALTER TABLE to modify a table.

 

We cannot use DROP TABLE to delete a query. To delete a query, use DROP VIEW .

 

The DROP TABLE statement is an action query and cannot be used from within the Manifold ODBC driver.

 

Attempting to delete a table bound to a drawing using DROP TABLE will fail with a descriptive error message.

 

Example

 

Delete a table named "Employees":

 

DROP TABLE [Employees];