The DROP TABLE statement is employed to remove a pre-existing table from a database.
| DROP TABLE table_name; |
| Caution: Exercise care prior to dropping a table. Deleting a table will lead to the irreversible loss of all data stored within it! |
The subsequent SQL statement removes the current table named “Shippers”:
| DROP TABLE Shippers; |
The TRUNCATE TABLE statement is employed to clear the data within a table, without removing the table itself.
| TRUNCATE TABLE table_name; |