Reset identity

• Identity property in MSSQL server auto increment column value.
• When we remove rows identity column continues with incerment value, but sometimes we need reset identity to predefined value.
• We have three choices:
  1. DBCC CHECKIDENT
  2. Drop and Add the column
  3. Drop and Create the table

DBCC CHECKIDENT ( <table name>,RESEED,<new value>)