Difference between truncate and drop

Data Science, AI and ML
,
#1

Sql, Statements

#2

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
#3

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

#4

DROP

Command removes a table from the database. All the tables’ rows, indexes and privileges will also be removed. No DML triggers will be fired. The operation cannot be rolled back.

TRUNCATE

Removes all rows from a table. The operation cannot be rolled back and no triggers will be fired. As such, TRUNCATE is faster and doesn’t use as much undo space as a DELETE.