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;
table_name is the name of the table to remove from the database.
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.