Truncate removes all data from a table while delete removes specific rows.

• Truncate is faster than delete as it doesn't log individual row deletions.

• Truncate resets the identity of the table while dele...read more

Truncate command delete all data at a time while delete command delete one row at a time

The DELETE statement removes rows one at a time and records an entry in the transaction log for each deleted row. TRUNCATE TABLE removes the data by deallocating the data pages used to store the table...read more