|
TG
Flowing Fount of Yak Knowledge
USA
5501 Posts |
 Posted - 05/02/2005 : 11:33:11
|
I don't think you can use ALTER TABLE ALTER COLUMN to change the identity property (either adding or removing). As far as I know you'd have to drop and re-create the column (or the whole table). And of couse deal with dropping and re-establishing any referential integrety and saving off existing data that you want to preserve.
Be One with the Optimizer
TG |
 |
|
Altering an Identity Column
Forum Locked
