Reset Identity PK field

Question

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply

David.Poole SSC Guru Points: 76001 More actions · Answer 1

If you want to reset an identity range then

DBCC CHECKIDENT('YourTable',RESEED,0)

If you want to explicitly add a record that over rides the identity then

SET IDENTITY_INSERT dbo.YourTable ON

INSERT Yourtable(PKField,OtherFields) VALUES (0,Yourvalues)

SET IDENTITY_INSERT dbo.YourTable OFF

govind-211283 SSC Eights! Points: 962 More actions · Answer 2

Hi David,

Thanks for the quick help. This solves my problem

Regards,

GB

Ryan Hathaway SSC Eights! Points: 827 More actions · Answer 3

If the table is empty, TRUNCATE TABLE user.tablename will do it as well.

govind-211283 SSC Eights! Points: 962 More actions · Answer 4

TRUNCATE works on empty table: this is also helpful. Thanks for this trick too.

Regards, GB