SQLDROP TABLE and TRUNCATE TABLE Keywords
DROP TABLE
TheDROP 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
TheTRUNCATE TABLE command deletes the data inside a table, but not the table itself.
The following SQL truncates the table "Categories":
Example
TRUNCATE TABLE Categories;
