Referential integrity across DB's
Can anyone give me some tips on how to best maintain referential integrity
across databases? I have multiple databases whose tables contain foreign
keys referencing primary keys in other database tables. I want to make sure
that a deletion cannot occur if tables in other databases are referencing
the record to be deleted. In other words, I don't want to orphan these records.
I was thinking of using triggers, but not sure if this is best.
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL