Enforcing Referential Integrity Across SQL Server Databases
Learn how to control referential integrity from parent table for tables that reside in different SQL Server databases on the same server.
Referential Integrity
Learn how to control referential integrity for database tables and data.
Referential Integrity for Tables in Different SQL Server Databases
Learn a way to build referential integrity for tables that reside in different SQL Server databases on the same server.
SQL Server Referential Integrity Across Databases Using Triggers
In this tip we cover how you can implement SQL Server cross database referential integrity using triggers.
SQL Server Referential Integrity without Foreign Keys
Usually referential integrity is implemented by using foreign key constraints, however there can be situations when it is not possible to create a foreign key constraint. Read this tip to learn about other options.
Foreign Key vs. Trigger Referential Integrity in SQL Server
In this article, we look when and how to use SQL foreign keys vs SQL triggers for referential integrity when working with SQL Server.