Can I alter an identity field to not be an identity field using T-SQL?

[sedrisco]

I have a number of tables that use an identity field as a primary key. I need to change the key of the table, and I'd like to leave the original key in the table, but to no longer be an identity field. Is there a way to do this using T-SQL? I tried the following, but it's not removing the identity propery:

alter table table1
alter column [table_id] bigint not null

Any suggestions?

Thanks!

 

[JayKusch]

Thsi link will get you there!

http://www.winscriptingsolutions.com/Articles/Index.cfm?ArticleID=22081

Thanks

J. Kusch

 

[sedrisco]

Thanks. I was hoping there was a way to do it without recreating the table, or adding a new field. I didn't realize that what Enterprise Manager did was recreate the table. I guess I will do that programatically.

Thanks again for your help.