The SQL DROP TABLE statement allows you to remove a table from the SQL database.
The syntax for the SQL DROP TABLE statement is:
DROP TABLE table_name;
DROP TABLE Statement - Example
Let's take a look at a simple SQL DROP TABLE statement.
For example:
DROP TABLE supplier;
This would drop table called supplier.