Aug 30 2005

Identity Columns in MS SQL Server

Category: Databases & SQLBil@l @ 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.

Regards

Tags: