How to reset identity ?

• Mark Shvarts 1

  SSCertifiable

  Points: 5702

  More actions

  August 8, 2006 at 9:56 am

  #113254

  I have a table with identity field and several foreign keys. Now I want to reset identity field to start from 1 . In order to clean up the table I can do only delete because foreign keys prevent me from doing truncate table.

  Is there a function , set command or any other method to reset identity without truncating or dropping/recreating a table ?

  Thanks

   

• Aaron Ingold

  SSCrazy Eights

  Points: 9070

  More actions

  August 8, 2006 at 9:57 am

  #653882

  Look up DBCC CHECKIDENT.

• Pedro R. Lopez

  SSC Eights!

  Points: 902

  More actions

  August 10, 2006 at 8:23 am

  #654327

  Truncate table will work too.

  Pedro R. Lopez
  http://madurosfritos.blogspot.com/[/url]