SQL DROP TABLE Statement

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

DROP TABLE Syntax

DROP TABLE table_name;

Important Points

• DROP a table very carefull; check DROP query once before dropping a table.
• Once deleting a table will result in loss of complete information stored in the table forever.

EXAMPLE: DROP TABLE

DROP The Upper SQL TABLE

DROP TABLE STUDENTS;

SQL TRUNCATE TABLE Statement

The SQL TRUNCATE TABLE statement is used to to remove all rows inside a table.

The TRUNCATE TABLE statement is not used to dalete the table itself.

TRUNCATE TABLE Syntax

TRUNCATE TABLE table_name;

TRUNCATE TABLE vs DELETE TABLE

TRUNCATE TABLE is faster and uses lesser resources than DELETE TABLE command.