Difference between truncate and delete and when we prefer what operation?

Question

Accepted Answer

Truncate removes all rows from a table, while delete removes specific rows. Truncate is faster but cannot be rolled back.

Truncate is a DDL operation while delete is a DML operation
Truncate resets the identity seed of the table, delete does not
Truncate is faster as it does not log individual row deletions, delete logs each row deletion
Truncate cannot be used on tables referenced by a foreign key constraint, delete can be used
Truncate operation cannot be rolled back, delete operation can be rolled back

Accepted Answer

TRUNCATE is a type of DDL command while DELETE is a kind of DML command. One can use TRUNCATE for deleting an entire set of data from a given table while the DELETE command only deletes specific data from the entire table.

Difference between truncate and delete and when we prefer what operation?

Top S&P Global Software Development Engineer II interview questions & answers

Popular interview questions of Software Development Engineer II