Suthish Nair

Suthish Nair

  • NA
  • 30.5k
  • 7.2m

Reset @@identity column - Which one is better

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

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

Answers (1)