How can I update the foreign keys to make them ON CASCADE UPDATE ?
EDIT 2: The information that you need is found in sys.foreign_keys.
Foreign key constraints are an integral part of SQL Server database design.
These are used to maintain integrity among related data in different tables.
, I see that update_referential_action is set to 0.
Thus NO ACTION is taken after updating my primary keys columns.Microsoft is conducting an online survey to understand your opinion of the Technet Web site.