Using SQL to Delete a Database Table

An easy way to delete an existing database table is through the use of an SQL (Structured Query Language) query. To execute SQL queries you will need to use the SQL query editor of your chosen database. For SQL server, use the Management studio to create a new query by right clicking on the database and selecting New Query.

To delete the table you must specify the table name after the drop table command. An example of this is below.

SQL Script:

DROP TABLE [TableName]

Return to all articles