Drop identitycolumn

hi.

i want to drop identity column in a table but not though design view, so plz tell the script for that.

Unfortunately, you cannot 'just' remove the IDENTITY property of a column. You have to completely remove the column.

Code Snippet

ALTER TABLE MyTable

DROP COLUMN MyColumn

If you wish to keep the values in the column, and just remove the IDENTITY property, you must first add another column, copy the existing values to the new column, and then DROP the existing IDENTITY column.

|||

This resource might be helpful:

http://www.bennadel.com/index.cfm?dax=blog:24.view