Wednesday, March 06, 2013

Reset Identity column in SQL Server

I keep Googling for how to do this, and now I'm just coming here the next time I need it

DBCC CHECKIDENT('Customer', RESEED, 0)

I got it from here:
http://geekswithblogs.net/TakeNote/archive/2007/11/30/117258.aspx

and sometimes from here:
http://blog.sqlauthority.com/2007/03/15/sql-server-dbcc-reseed-table-identity-value-reset-table-identity/

No comments: