21 September 2014

SQL Tip: Resetting Identity seed

After deleting your db table, if you want your identity column to start from 1 again

DBCC CHECKIDENT('TableName', RESEED, 0)
Posted by at
Tags: ,

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)