Alter Table - Drop IDENTITY

[agoeddeke]

Hello,

Is there a way using the ALTER TABLE command that I can drop the IDENTITY property from a column?

I'd like to drop just this setting rather than dropping the entire column and re-adding.

Thanks,
Andy

 

[JayKusch]

You can use Enterprise Manager by opening the table in design view and changing the properties of the column.

In T-SQL, you would need to copy the data into a temporary table, drop the old table, create a new table without the identity, and copy the data back. Be sure you recompile dependent objects.

Thanks

J. Kusch

 

[agoeddeke]

Jay,

Thanks for the info. I also found this link from one of your previous posts on the issue:

http://www.winnetmag.com/WindowsScripting/Article/ArticleID/22081/WindowsScripting_22081.html

Andy