Monday, 4 June 2012

SQL Server Reset identity column value of table

DBCC CHECKIDENT (Table_Name, RESEED, New_Reseed_Value)

EX: DBCC CHECKIDENT ('UserDetails', RESEED, 0)

No comments:

Post a Comment