Here is the Alter Table Statement for doing that:
Example:
Showing posts with label TSQL. Show all posts
Showing posts with label TSQL. Show all posts
Saturday, April 3, 2010
Reseeding Identity Column in SQL Server / TSQL
ShareThis
Sometimes we need to change the seed value in Identity Column in a Table in SQL Server.
Here is the Alter Table Statement for doing that:
DBCC CHECKIDENT('', RESEED, )
Example:
DBCC CHECKIDENT('Students', RESEED, 12)
Here is the Alter Table Statement for doing that:
Example:
Subscribe to:
Posts (Atom)