February 19, 2004 at 2:42 am
How can I remove the IDENTITY contraint for a column in my table.
February 19, 2004 at 3:24 am
Please avoid double postings.
Let's continue here
http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=101113
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url]
February 19, 2004 at 8:20 pm
One way of doing:
alter table add
update the new column with identity column
alter table drop
February 20, 2004 at 7:53 am
If doing it manually is an option, then you can use Enterprise Manager. If you want a script to remove it you can go to the design view in Enterprise Manager, set identity = No, and then click the Save Change Script button.
Robert W. Marda
Billing and OSS Specialist - SQL Programmer
MCL Systems
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply