Friday, March 28, 2014

How to reset Identity column in SQL Server

Execute Below query

DBCC ( 'tableName',RESEED,0)

Note : DBCC stands for Database Consistency Check. it is a system define function to RESEED the Identity Column in the supplied table.

No comments:

Post a Comment