Reset Identity Field

[Waynest]

Hello

I have a system which is to go live in the next week or two.

A few of my tables have fields of type 'int' where they are set up as identity fields (Autonumber).

I would like the identity fields to start counting from 1 when the system goes in, how do I reset them?

Thanks

 

[mitchadams]

try something like this

dbcc checkident(tablename,reseed,1)

you will need to have deleted the data or truncated the tables first.