DBCC CHECKIDENT (tablename, NORESEED)
To set the next identity value to 100 for a table use:
DBCC CHECKIDENT (tablename, RESEED, 99)
Note that the next value will be whatever you reseed + 1.
Tuesday, 8 September 2009
Reset Identity Column in SQL Server
To check the current value of an identity field use:
To set the next identity value to 100 for a table use:
Note that the next value will be whatever you reseed + 1.
To set the next identity value to 100 for a table use:
Note that the next value will be whatever you reseed + 1.
Subscribe to:
Comments (Atom)