title: SQL Server - Insert and update specification (Foreign key relationship)
body: <p>I just want to know if there is any way to write some function or stored procedure in sql server to change the <strong>delete rule</strong> programmatically?</p>
  
  <p>Example: I have to change the delete rule from <strong>Cascade</strong> to <strong>none</strong> or vice versa but I don't want to do graphically. </p>
  
  <p>Because I have to do quite often and want to revert it back to its initial stage.</p>