SQLServer Identity column removal

[saimagulse]

Hi all
If we have define a column having identity property=yes and save the table . we can also remove it from Enterprise manager. But i want to know he script to remove identity property of this column. This is not done through alter table statement. How it is possible please help me. ame case if for Default property of column

 

[gmmastros]

As far as I know, there is no simple way to remove an identity property. You could...

1. Add another column
2. Copy the data from the identity column to this other column
3. Drop the identity column
4. Rename the column (made in step 1) with the name of the original identity column.
5. Recreate indexes and foriegn keys.

-George

Strong and bitter words indicate a weak cause. - Fortune cookie wisdom