SQL DROP TABLE and TRUNCATE TABLE Keywords
DROP TABLE
The DROP TABLE
command deletes a table in
the database.
The following SQL deletes the table "Shippers":
Example
DROP TABLE Shippers;
Note: Be careful before deleting a table. Deleting a table results in loss of all information stored in the table!
TRUNCATE TABLE
The TRUNCATE TABLE
command deletes the data inside a table, but
not the table itself.
The following SQL truncates the table "Categories":
Example
TRUNCATE TABLE Categories;