Coding is fun...
"Programmers are a device for turning caffeine into code."
Pages
Blog Posts
Random readable
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)
0 comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
0 comments:
Post a Comment