Select from following answers:- Resets the identity column to the seed of the column
- Removes all records from the table.
- It cannot be used on tables referenced by foreign tables.
- Delete triggers are executed.

- All Above
When the contents of a table are removed using the TRUNCATE TABLE command, delete triggers are not executed. Delete triggers are only triggered when the DELETE command is used.
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator