SQLSERVER: how to change an existing primary key of an int table to become an identity column?

Question

My database has a table with thousands of records. The primary key is an integer. There are many foreign key restrictions in this column.

I want to change this column to become an identity key. What is the best way to do this? I also need to send this update to install our clients.

Reward points for a response that runs on Sql Server 2000.

+5

neves Jun 23 '09 at 23:10

4 answers

Enterprise Manager , .

(, , , , , - 1

+1

Stuart 23 . '09 23:15

"ALTER TABLE" DDL . .

, script -, fk.

+1

, . ! .

ALTER TABLE , Enterprise Manager.

0

Raj More 23 . '09 23:29

neves · Accepted Answer · 2009-06-24T00:04:36+0000

SQL Server Management Studio has a great feature that saved my day.

SSMS "" → "" → " ", " " " , ".

, Identity. . " " "()" "". " script". .

script, constrainsts, . WOW!

.

: . , script .

. , , , 3 !