Describe truncate commands

Question

Describe truncate commands.

Answer 1

Truncate:

• Truncate command is utilized to remove each row of the column.
• The eliminated records are not recorded within the transaction log.
• This is the fast way to remove all the records by the table.
• The records once detached cannot be rolled back.
• This can’t activate trigger.
• This resets the identity of the column.