How to delete a table in SQL ?

There are two ways to delete a table from sql: DROP and TRUNCATE. The DROP TABLE command is used to completely delete the table from the database. This is the command:


DROP TABLE table_name;

The above command will completely delete all the data present in the table along with the table itself.

But if we want to delete only the data present in the table but not the table itself, then we will use the truncate command:


DROP TABLE table_name ;
How to delete a table in SQL ?

Published on 12-Dec-2021 20:41:30

You may also like this!