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.