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}