Search code examples
sql-serverforeign-keysrestriction

Alter Attribute of restriction of the Foreign Key


I need to alter Attribute of restriction of the Foreign Key with script. Is it Possible without dropping the key and recreating it?


Solution

  • AFAIK dropping the constraint and then recreating it with your new attribute is the only way.