SQL DROP TABLE and TRUNCATE TABLE Keywords

DROP TABLE

The DROP 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!

Continue reading SQL DROP TABLE and TRUNCATE TABLE Keywords