Deletes an existing table, procedure, or view from a database, or deletes an existing index from a table.
Note The Microsoft Access database engine does not support the use of DROP, or any of the DDL (Data Definition Language (DDL): The language used to describe database attributes, especially tables, fields, indexes, and storage strategy. ANSI defines this to have the tokens CREATE, DROP, and ALTER. DDL is a subset of structured query language (SQL).) statements, with non-Microsoft Access databases. Use the DAO (Data Access Objects (DAO): A programming interface that you can use to access and manipulate database objects.) Delete method instead.
Syntax
DROP {TABLE table | INDEX index ON table | PROCEDURE procedure | VIEW view}
The DROP statement has these parts:
| Part |
Description |
| table |
The name of the table to be deleted or the table from which an index is to be deleted. |
| procedure |
The name of the procedure to be deleted. |
| view |
The name of the view to be deleted. |
| index |
The 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.
