Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

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 statements, with non-Microsoft Access 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.



Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×