By using cascading referential integrity constraints, you can define the actions that SQL Server 2005 takes when a user tries to delete or update a key to which existing foreign keys point.

BR>Introducing FOREIGN KEY constraint 'FK_Games_Publishers' on table 'Games' may cause cycles or multiple cascade paths. Specify ON DELETE NO ACTION or ON UPDATE NO ACTION, or modify other FOREIGN ...

-- Name: secu_edit_acces_immeubles secu_edit_acces_immeubles_fk_regie_id_fkey; Type: FK CONSTRAINT; Schema: securite; Owner: <user> ALTER TABLE ONLY securite.secu ...

FOREIGN KEY: Establishes a relationship between two tables; can be configured to enforce referential integrity with constraints like ON DELETE CASCADE or ON UPDATE CASCADE ... SHOW CREATE TABLE: ...

{Microsoft][SQL Server Native Client 10.0][SQL Server]The UPDATE statement conflicted with the FOREIGN KEY constraint “FK_ModelElementData_HasModelId_LayerId”. The conflict occurred in database “AXDB” ...