Microsoft Access Database Development With VBA

SQL: Deleting a Table

   

Description

To delete a table in the SQL, create a DROP TABLE expression followed by the name of the table. The formula to use is:

DROP TABLE TableName;

Replace the TableName factor of our formula with the name of the table you want to delete.

Here is an example:

DROP TABLE Departments;
     
 

Home Copyright © 2009-2016, FunctionX, Inc. Home