Deletes an existing table from a database or deletes an existing index from a table.
Note The Microsoft Jet database engine doesn’t support the use of DROP, or any of the DDL statements, with non-Microsoft Jet databases. Use the DAO Delete method instead.
Syntax
DROP {TABLE table | INDEX index ON table}
The DROP statement has these parts:
Part | Description |
table | Name of the table to be deleted or the table from which an index is to be deleted. |
index | Name of the index to be deleted from table. |
Remarks
You must close the table before you can delete it or remove an index from it.
You can also use ALTER TABLE to delete an index from a table.
You can use CREATE TABLE to create a table and CREATE INDEX or ALTER TABLE to create an index. To modify a table, use ALTER TABLE.