SQL Server – Reset Identity Column Value

Posted: April 11, 2012 in SQLServer
Tags: ,

To check the current identify value – DBCC CHECKIDENT (RetailForm, NORESEED)

If above statement returns 44 as value that means the table has a record with current highest identity value – 44 .

If you want to skip next 10 identity ids and want to start the new record’s identity from 55 then you can run following command

DBCC CHECKIDENT (RetailForm, RESEED, 54)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s