Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
How to convert a column into IDENTITY
Message
 
 
To
15/04/2002 15:27:21
General information
Forum:
Microsoft SQL Server
Category:
SQL syntax
Miscellaneous
Thread ID:
00645152
Message ID:
00645154
Views:
10
This message has been marked as a message which has helped to the initial question of the thread.
>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--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform