SQL Server Architecture Interview Question:

Explain the truncate command?

Submitted by: Administrator

Truncate command is used to remove all rows of the column.
The removed records are not recorded in the transaction log.
It is the fast way to remove all the records from the table.
The records once removed can't be rolled back.
It can't activate trigger.
It resets the identity of the column.
Submitted by: Administrator