Wednesday, December 14, 2011

How To Reset Identity column in SQL Server


The following line resets the Identity value for the table to 0 so that the next record added starts at 1.

DBCC CHECKIDENT('table_name', RESEED, 0)
Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)