How to reset Identity Increment value in MS SQL

Why not join our community?, there are 12 users online

home
architecture
view story

DotNetKick.com is an open-source project. Please report any bugs and let us know your great suggestions. Currently running svn revision 620 (rss)

Kick Spy!, Kick Zeitgeist and Kick Widgets

16
kicks

kick it

How to reset Identity Increment value in MS SQL

published 3 months, 4 days ago, submitted by shaharab 3 months, 4 days ago

devmuse.com — An Identity column in SQL Server is used to auto number the rows. When you delete rows from the table, the identity will not reset but you have few options of doing it yourself.

2 comments | category:

Architecture | Views: 36 | Get KickIt image code

tags: SQLServer, SQL, Database | tag it

Everyones tags:

Your tags:

Please login or signup.

Add a live kick counter to your blog >> liveImage

You can even customize the image by choosing your own colors, and then clicking the button below to update the preview and the html code:

"Kick It" text
"Kick It" background
kick count text
kick count background
border

Simply copy and paste this HTML into your blog post.

Users who kicked this story:

shaharab - galiyr - m_bearach - shaharyr - locrain - eugenciuta -

superghost - razamit - hbazerbashi - adventurer - Vort3X - jessenaiman - blisteringlunatic - khushal999p -

mdopp - adammal

Comments:

Of the three methods, the first looks like the only method to maintain FK relationships. My real question though, is why would you bother with this at all. I'm sure there are reasons related to aesthetics on one level or another. I suppose you might also run out of IDs at some point, but with int (or bigint) theree are a lot of IDs to use and most systems that I can imagine would never reach that limit.

posted by

daughtkom 3 months, 4 days ago

I Agree that running out of IDs is not the problem, but sometimes its just convinient to reset the id when you clear table data. as i mentioned, if you use methods 2 or 3 your have to take care of all PK/FK yourself...

posted by shaharab 3 months, 3 days ago