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.
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