Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Cannot create primary key
Message
 
 
To
27/03/2015 09:34:38
General information
Forum:
Microsoft SQL Server
Category:
Other
Environment versions
SQL Server:
SQL Server 2012
Application:
Web
Miscellaneous
Thread ID:
01617314
Message ID:
01617324
Views:
32
>Ok, I found why.
>
>A previous table Report got renamed to ReportApplication. It had a ReportNumero primary key. Once I rename the table, I need to rename that primary key. All primary keys need to be unique in the database it seems.

Yes, all constraints names need to be unique across database - something to keep in mind.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform