Toad World® Forums

Referential integrity triggers


#1

I'd like to have the ability to define referential integrity triggers based on table relationships, instead of having foreign key constraints. I know that FK constraints are much more efficient, but having trigger templates for relationships helps me better customize all checks and custom messages. For example, Erwin lets define trigger templates based on the relationship type, and it is also cross platform.