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.
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center