Sql updating tables with foreign keys

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.



  1. Pingback:

  2. eric   •  

    After an appeals court overturned parts of the conviction, Ravi pleaded guilty to one count of attempted invasion of privacy on October 27, 2016.

  3. eric   •  

    De lente verliep aanvankelijk wel aan de koude kant, maar omdat mei te warm was, werd het cijfermatig toch een normale lente.

  4. eric   •  

    The internet is full of scammers, so you need to keep your eyes open and know what to look out for.

  5. eric   •  

    has great instant messenger and live video Toronto chat service for our members.

  6. eric   •  

    And Jorgie Porter has sparked speculation she could have found someone outside of Celebs Go Dating, stepping out in Chelsea, west London with a mystery man on Thursday.

  7. eric   •  

    They have a scientifically proven compatibility method and are responsible for nearly 5% of all marriages in the U. If you are serious about finding a committed, loving relationship, then check out our review and signup for e Harmony to review your matches for free!

  8. eric   •  

    Meet thousands of fun, attractive, Grand cayman men and Grand cayman women for FREE. Click on any of the cities in Grand cayman below to meet members looking to chat with you.

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>