Discussion Forum | Board Infinity

Difference between truncate and drop

Sql, Statements

TRUNCATE Command is a Data Definition Language operation. It is used to remove all the records from a table. It deletes all the records from an existing table but not the table itself.

DROP statement is a Data Definition Language(DDL) Command which is used to delete existing database objects. It can be used to delete databases, tables, views, triggers, etc.

1 Like

TRUNCATE removes all rows from a table. The DROP command removes a table from the database.