Aug 30 2005

Identity Columns in MS SQL Server

Category: Databases & SQL[email protected] @ 10:17

When working with Identity Columns in MS SQL Server, and specially when testing your database and inserting some junk data for the sake of testing, you ask yourself, how would I reset my Identity Columns to their original values after I finish testing with the junk data?

dbcc checkident (Table1, reseed, 1)

Hope that helps.