title: How to make multiple referential integrity conditions in SQL
body: <p>I have a SQL statement that should add me some constraints. In that statement I want to set on two constraints two referential integrity conditions.</p>
  
  <p>Here is my statement:</p>
  
  <pre><code>ALTER TABLE Vertraege
      ADD CONSTRAINT FK_Kunde_Vertraege FOREIGN KEY(K_ID)
          REFERENCES Kunde(K_ID),
      CONSTRAINT FK_Standort_Vertraege FOREIGN KEY(S_ID)
          REFERENCES Standort(S_ID) ON UPDATE CASCADE ON DELETE CASCADE,
      CONSTRAINT FK_Mitarbeiter_Vertraege FOREIGN KEY(M_ID)
          REFERENCES Mitarbeiter(M_ID) ON UPDATE CASCADE ON DELETE CASCADE,
      CONSTRAINT FK_Dienstleistung_Vertraege FOREIGN KEY(D_ID)
          REFERENCES Dienstleistung(D_ID),
      CONSTRAINT FK_Compliance_Vertraege FOREIGN KEY(C_ID)
          REFERENCES Compliance(C_ID);
  </code></pre>
  
  <p>So the problem ist, that I get an error because of this.</p>
  
  <pre><code>Notification 1785, level 16, status 0, line 28
  Introducing FOREIGN KEY constraint 'FK_Mitarbeiter_Vertraege' on table 'vertreage' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN KEY constraints.
  Notification 1750, level 16, status 1, line 28
  Could not create constraint or index. See previous errors.
  </code></pre>
  
  <p>Is it possible to set multiple referential integrity conditions and if not, how can I make multiple of them in SQL? Something like <code>ALTER CONSTRAINT</code>...</p>
  
  <p><strong>EDIT</strong></p>
  
  <p>Brian asked for this. On my table mitarbeiter I have following constraints. The strange thing is, they work</p>
  
  <pre><code>ALTER TABLE Mitarbeiter
      ADD CONSTRAINT FK_Adresse_Mitarbeiter FOREIGN KEY(AD_ID)
          REFERENCES Adresse(AD_ID) ON UPDATE CASCADE,
      CONSTRAINT FK_Standort_Mitarbeiter FOREIGN KEY(S_ID)
          REFERENCES Standort(S_ID) ON UPDATE CASCADE,
      CONSTRAINT FK_Abteilung_Mitarbeiter FOREIGN KEY(AB_ID)
          REFERENCES Abteilung(AB_ID) ON UPDATE CASCADE;
  </code></pre>