DDL - DROP
Use
DROP objectname
to remove from the database any object that was CREATEd.
In MS Access, we can only
DROP tables and indexes.
Exercise:
Remove the CategoriesNoPix table from the database - we no
longer need
it.
1. Type the following statement in the SQL
window:
DROP TABLE CategoriesNoPix;
2. Execute the statement.
3. Check the table list - the table should be
gone.
4. Save and close the DROP query (optional).
Syntax
DROP {TABLE tablename |
INDEX indexname ON
tablename}