The DROP TABLE command removes a table from the database.
The provided SQL deletes the table named “Shippers”:
| DROP TABLE Shippers; |
| Note: Exercise caution before deleting a table, as doing so will result in the loss of all information stored in the table! |
The TRUNCATE TABLE command removes all data inside a table while preserving the table structure.
The following SQL truncates the table named “Categories”:
| TRUNCATE TABLE Categories; |