Constraints Versus Triggers

Good DBMS’s support the use of triggers (blocks of SQL code that execute when an event occurs), and constraints (rules associated with datatypes or columns). Both can (and should) be used to enforce data integrity and consistency, but as a rule, constraints execute quicker than triggers. (Applies to: ColdFusion All)

Leave a Reply