开发者

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

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

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜