Saturday, 19 March 2011

Reset Identity Column use CHECKIDENT Command

Reset Identity Column : DBCC CHECKIDENT (Table_Name, RESEED, 0)

If you are using an identity column on your SQL Server tables, you can set the next insert value to whatever value you want.
Ex:- DBCC CHECKIDENT (Table_Name, RESEED, 100)
Now your identity number start with 101 Number.


No comments:

Post a Comment