. What is the difference between TRUNCATE and DELETE commands?

The main differences between the TRUNCATE and DELETE commands in SQL are:

Purpose:

DELETE: Removes specific rows from a table based on a condition (WHERE clause).
TRUNCATE: Removes all rows from a table without any conditions.
Performance:

DELETE: Slower, especially for large datasets, because it logs individual row deletions and can trigger triggers.
TRUNCATE: Faster, as it deallocates data pages and does not log individual row deletions.
Transaction Control:

DELETE: Can be rolled back if used within a transaction.
TRUNCATE: Cannot be rolled back in some database systems once executed, although it may be part of a transaction in others.
Identity Reset:

DELETE: Does not reset any identity columns.
TRUNCATE: Resets identity columns to the seed value.
Table Structure:

DELETE: Does not affect the table structure; constraints and triggers remain in place.
TRUNCATE: Maintains the table structure but removes all data.
In summary, use DELETE for conditional row removal and TRUNCATE for efficiently clearing a table’s data.