Drop and Truncate statement in SQL

Question

What is difference between drop and truncate statement in SQL.

Jignesh Trivedi · Answer

hi, Removes all rows from a table without logging the individual row deletions. TRUNCATE TABLE is similar to the DELETE statement with no WHERE clause; however, TRUNCATE TABLE is faster and uses fewer system and transaction log resources.TRUNCATE TABLE cannot activate a trigger because the operation does not log individual row deletions. TRUNCATE TABLE table1; The SQL DROP command is used to remove an object from the database. If you drop a table, all the rows in the table is deleted and the table structure is removed from the database. DROP TABLE table1; hope this will help you.

krishna prasad · Answer

Truncate and Delete statement deletes all the records in the table but retains the table structure Whereas as drop statement drops the entire table and its structure.

Vulpes · Answer

When applied to a table in a database: TRUNCATE TABLE removes all rows from the table without logging the individual row deletions. In contrast, DROP TABLE removes the entire table from the database.

Drop and Truncate statement in SQL

Answers (3)