John's Technical Blog
Friday, 30 October 2009
SQL: Reset column identity
--Check what currently is
DBCC CHECKIDENT (’tablename’, NORESEED)
--Reset
DBCC CHECKIDENT (’tablename’, RESEED, 1)
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment