SQLDROP TABLE Statement
The SQL DROP TABLE Statement
TheDROP TABLE statement is used to drop an existing table in a database.
Syntax
DROP TABLEtable_name;
Note: Be careful before dropping a table. Deleting a table will result in loss of complete information stored in the table!
SQL DROP TABLE Example
The following SQL statement drops the existing table "Shippers":
Example
DROP TABLE Shippers;
SQL TRUNCATE TABLE
TheTRUNCATE TABLE statement is used to delete the data inside a table, but not the table itself.
Syntax
TRUNCATE TABLEtable_name;
