Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Set up a field as auto increment
Message
General information
Forum:
ASP.NET
Category:
Databases
Miscellaneous
Thread ID:
01216349
Message ID:
01216403
Views:
17
>I have tbale which has a Primary Key.
>I now want to set it to autoincrement.
>I ritht cick on the column, but the iDENTITY field is disabled.
>
>Is there a way to change a PK to be Autoincrementing.
>Regards,
>Gerard

Are you trying to do this from VS (through the server explorer) or using SQL Server Management Studio?
Is the PK an (exact) numeric field?
I do not have any problems changing the Identity Specification in the column properties to Yes and then changing the identity increment property.
Semper ubi sub ubi.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform