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)

No comments:

Post a Comment