How to delete a table in SQL?

Question

Can anyone tell me how to delete a table in SQL?

Answer 1

We can delete the total table in SQL by using DROP statement. Here is the syntax to delete the table in SQL:

DROP TABLE TableName;

We can delete all the records from the table but not the table itself by using TRUNCATE statement. Here is the syntax to delete the data in the table in SQL but not the table itself:

TRUNCATE TABLE TableName;

If you want to learn SQL, you can go through this SQL tutorial blog by Intellipaat.