Select from following answers:- WHERE clause is not optional as it will remove all data from your table.
- Will not fire triggers.
- Reseeds the identify value of an identity column.
- Cannot be used on a table which is referenced by a foreign key constraint.
- All Above
Above all statements are correct about Truncate command as it does not fire Trigger associated with Tables and also resets the identity column value to start from 1 again.
Show Correct Answer
Asked In: Many Interviews |
Alert Moderator