SQL Server Architecture Question:
Explain the truncate command?
Answer:
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.
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.
| Previous Question | Next Question |
| Can you explain what are the restrictions applicable while creating views? | Explain the Microsoft SQL Server delete command? |