SQL Server – Reset Identity Column

Posted on 12/07/2012 by eSearing

How to reset the identity counter in SQL SERVER

DBCC CHECKIDENT('tablename', RESEED, 0)

The zero can be any positive value. I often use the year as numbering system like 2012000001

Cup size   
Select size then click on coffee cup.
This entry was posted in Snippets, SQL. Bookmark the permalink.