开发者

Rename foreign key system name in SQL Server Management Studio is failing

开发者 https://www.devze.com 2022-12-11 04:12 出处:网络
The method or operation is not permitted. I assume this is a permission开发者_StackOverflow社区\'s issue, but I can\'t figure out where I would change it. It is strange because I can rename an inde

The method or operation is not permitted.

I assume this is a permission开发者_StackOverflow社区's issue, but I can't figure out where I would change it. It is strange because I can rename an index with no issue.

EDIT:

If you're looking at a table, and you see "Columns, Keys, Constraints, etc.", this is under Keys, and it is the system name that I presume SQL is using to identify the foreign key name I gave the column.


What is the exact error you are getting?

Also, generate a script for your change and paste that script into a query window and try it there. See what the error is. Note that SSMS GUI stuff is NOT the best place to do stuff like this.

0

精彩评论

暂无评论...
验证码 换一张
取 消