Which statement is/are correct about Truncate command?

 Posted by vishalneeraj-24503 on 2/3/2015 | Category: Sql Server Interview questions | Views: 2093 | Points: 40
Select from following answers:
  1. WHERE clause is not optional as it will remove all data from your table.
  2. Will not fire triggers.
  3. Reseeds the identify value of an identity column.
  4. Cannot be used on a table which is referenced by a foreign key constraint.
  5. All Above

Show Correct Answer

Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response