Use DROP TABLE statements to delete a table and all the data it contains from a data source.

DROP TABLE Syntax

The DROP TABLE statement accepts the name of the table to delete, as shown in the following example:

DROP TABLE [ IF EXISTS ] <table_name>

The following query deletes the MyCustomers table and its data from the server:

DROP TABLE IF EXISTS MyCustomers