SQL DROP TABLE Statement


The SQL DROP TABLE Statement

The DROP TABLE statement is used to drop an existing table in a database.

Syntax

DROP TABLE table_name;

Note: Be careful before dropping a table. Deleting a table will result in loss of complete information stored in the table!


SQL DROP TABLE Example

The following SQL statement drops the existing table "Shippers":

Example

DROP TABLE Shippers;

SQL TRUNCATE TABLE

The TRUNCATE TABLE statement is used to delete the data inside a table, but not the table itself.

Syntax

TRUNCATE TABLE table_name;

Test Yourself With Exercises

Exercise:

Write the correct SQL statement to delete a table called Persons.

 Persons;

Start the Exercise


Copyright 1999-2023 by Refsnes Data. All Rights Reserved.