DROP Statement

Microsoft Office Access 2003

DROP Statement

Deletes an existing table, procedure, or view from a database, or deletes an existing index from a table.

Note  The Microsoft Jet database engine> does not 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 | 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.

See Also
ADD USER Statement CREATE TABLE Statement
ALTER USER or DATABASE Statement CREATE USER or GROUP Statement
ALTER TABLE Statement CREATE VIEW Statement
CONSTRAINT Clause DROP USER or GROUP Statement
CREATE INDEX Statement GRANT Statement
CREATE PROCEDURE Statement REVOKE Statement