ansaurus

Question

Increase value of an identity column in SQL Server without dropping and recreating the table

Answer 1

+10 A:

DBCC CHECKIDENT (yourtable, reseed, 9999)

This will make the next entry 10000.

TheTXI 2009-06-12 14:46:33

I may be off one here, can't remember.

TheTXI 2009-06-12 14:47:19

10000 or 10001 does not matter in this case - your code works, thanks! :)

Kjensen 2009-06-12 14:48:16

Doing it through the GUI drops and recreates the table - I Know because that's what I did before asking the question, and got a warning smacked in my face. ;)

Kjensen 2009-06-12 15:04:03

Ah, good point there. I'll edit to revert back to my old statement of not stating anything else.

TheTXI 2009-06-12 15:06:12

Answer 2

+1 A:

This should do it:

DBCC CHECKIDENT (MyTableName, RESEED, 9999)

Matt 2009-06-12 14:48:44

That will make the next entry be 10001. I made the same mistake previously.

TheTXI 2009-06-12 14:50:50

@TheTXI - You are correct and I've updated accordingly. Thanks.

Matt 2009-06-12 16:02:49

ansaurus

tags:

views:

answers:

Increase value of an identity column in SQL Server without dropping and recreating the table

related questions