SQL Server Architecture Question: Download Questions PDF
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.
Download MS SQL Server Architecture Interview Questions And Answers
PDF
| Previous Question | Next Question |
| Can you explain what are the restrictions applicable while creating views? | Explain the Microsoft SQL Server delete command? |