DDL - DROP
Use DROP objectname to remove from the database any object that was CREATEd.
In MS Access, 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}