Is there a way to renumber an Identity column?

[jaylou]

I have a table with an Identity column. When rows are deleted the Sequence goes out of whack, Is there a way to restart the numbering at 1 and go to whatever?

TIA,
Joe

 

[vongrunt]

See DBCC CHECKIDENT with RESEED option in Books Online... together with some limitations explained there.

------
[small]<this is sig>
select stuff(stuff(replicate('<P> <B> ', 14), 109, 0, '<.'), 112, 0, '/')
</this is sig>[/small]

 

[jaylou]

Thanks,
Doesn't reseed only deal with new rows coming into the table? I want to update the present rows back to 1 thru blah, right now my table starts at 7,8,9,23,45,56,57,58,59...

Thanks again

 

[r937]

my sincere advice is: don't do it

just leave the numbers alone

if you are using them for anything, you shouldn't be

if you could tell us what that is, we might be able to help you do what you want to do without renumbering them

r937.com | rudy.ca