title: Cannot add cascade on update on two column of table referencing to same table same column
body: <p>I'm using SQL Server.</p>
  <p>I have one table named <code>PROGRAM_MASTER</code> which has two columns <code>created_by</code> and <code>updated_by</code> which are referencing to <code>USERS</code> table on column <code>id</code>.</p>
  <p>Now I want to define cascade on update option to both these columns using below SQL command.</p>
  <pre><code>alter table program_master add constraint program_master_created_by_foreign foreign key (created_by) references users (id) on update cascade
  
  alter table program_master add constraint program_master_upated_by_foreign foreign key (updated_by) references users (id) on update cascade
  </code></pre>
  <p>But foreign key constraint gets added to <code>created_by</code>, but while creating one for <code>updated_by</code> I get following error.</p>
  <blockquote>
  <p>SQLSTATE[42000]: [Microsoft][ODBC Driver 17 for SQL Server][SQL
  Server]Introducing FOREIGN KEY constraint
  'program_master_updated_by_foreign' on table 'program_master' may
  cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or
  ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.</p>
  </blockquote>
  <p>How should I resolve this error?</p>