Wednesday, January 9, 2013

DROP TABLE Statement


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.