The DROP TABLE statement is used to delete an existing table from a database.
| DROP TABLE table_name; |
| Note: Exercise caution before dropping a table. Deleting a table will lead to the permanent loss of all information stored within it! |
The SQL statement below drops the existing table named ‘Shippers’
| DROP TABLE Shippers; |
The TRUNCATE TABLE statement is used to remove all data from a table, while keeping the table structure intact.
| TRUNCATE TABLE table_name; |