>> Just wondering if anyone has run into an issue of whether to maintain
referential integrity via the application or via database constraints.
What is the issue? You can NEVER maintain referential integrity via an
application. Trying to kludge that would leave the entire schema wide
open to any future user to subvert.
referential integrity in the database .. <<
Unh?? Assuming that speed is more important than data integrity, this is
still a false argument. DRI clauses are predicates; they can be used by
the optimizer in a smart RDBMS system to great advantage.
CreditCardType table, ...