Identity column - seed value

• Joel Huffman

  SSC Journeyman

  Points: 78

  More actions

  July 15, 2003 at 6:32 am

  #83804

  I would like to truncate a large table (12 million rows) but retain the current value of the identity column. I know I can do this through enterprise manager by changing the seed value after truncating and I know that the delete will not reset the value. How can I set the seed value in a Tsql?

  Thanks

• Allen Cui-55137

  SSC Guru

  Points: 51650

  More actions

  July 15, 2003 at 6:45 am

  #465531

  This example forces the current identity value in the jobs table to a value of 0.

  USE pubs

  GO

  DBCC CHECKIDENT (jobs, RESEED, 0)

  GO