>Hello,
>
>I would like to convert an integer column into the identity column without droping and recreating it, since it is in the first position, where I want it. It can can be done with the enterprise manager, but I haven't figured out the correct ALTER TABLE statement.
>
>TIA,
>
>Alex
See
http://www.sqlmag.com/Articles/Index.cfm?ArticleID=22080.
--sb--