The DROP TABLE command removes a table from the database.
The provided SQL statement deletes the table named “Shippers”.
| DROP TABLE Shippers; |
| Caution: Exercise caution before deleting a table as it leads to the loss of all data stored within it! |
The TRUNCATE TABLE command removes all data within a table while retaining the table structure.
The given SQL truncates the “Categories” table.
| TRUNCATE TABLE Categories; |