1
Reply

Reset @@identity column - Which one is better

Suthish Nair

Suthish Nair

Oct 15 2010 3:02 PM
2.5k
DBCC CHECKIDENT('TableName', RESEED, 0)
truncate table dbo.TableName 

which one is better to reset @@identity column. Lets have a discussion.

Answers (1)