How to delete a table in SQL ?

DatabaseSQL

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 ;
     
Updated on 12-Dec-2021 20:41:30

0 Views

Previous Page Print Page Next Page  
Advertisements

ads