resetting identity seed

[foxitaly]

I need to reset the identity seed to the starting value after deleting all records

How to ?

thanks

 

[jby1]

The only way I know of to do it is to drop the table and recreate it again.

If you have deleted all of the records this should be ok?

 

[tapks]

Following is the way to reset the identity seed after deleting all the records.

DBCC CHECKIDENT ('table name', RESEED, starting value-1)

 

[JayKusch]

From what I am reading ... "reset the identity seed to the starting value after deleting all records" means that you plan to DELETE all the records of this table SO ...

TRUNCATE TABLE MyTable

This will delete all the records from the table and WILL reset your Identity Seed value to it initial value, in most cases Zero.

Thanks

J. Kusch