Answers

Question and Answer:

  Home  MS SQL Server Architecture

⟩ Explain the truncate command?

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.

 121 views

More Questions for you: