CODEWITHSUNDEEP
sqlforeign-keysindexing
user4903
user4903

Reputation:

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'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.

Upvotes: 2

Views: 858

Answers (1)

TheSQLGuru
TheSQLGuru

Reputation: 11

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.

Upvotes: 1

Related Questions