Reseting Indentity Column of a Table

• Ravikumar-157394

  SSC Enthusiast

  Points: 111

  More actions

  July 22, 2004 at 1:58 am

  #85926

  How to Reset the value of an Identity column in SQL Server Table

• Nivedita Sundar.N

  Mr or Mrs. 500

  Points: 556

  More actions

  July 22, 2004 at 6:58 am

  #515661

  Hi Ravi,

    You can change the seed value of identity column by using the statement

  DBCC CHECKIDENT ('table_name', RESEED, new_reseed_value)

  By using the truncate command the identity column is reset to the seed value.

  Hope this answers your query.

  Nivedita Sundar.N

   

• Nivedita Sundar.N

  Mr or Mrs. 500

  Points: 556

  More actions

  July 22, 2004 at 11:29 pm

  #515789

  Hi Ravi,

  The truncate option wont work for columns with dependencies. The DBCC CHECKIDENT will work.

  Nivedita Sundar.N