triggers & integrity constraints
diff between triggers & integrity constraints?
Constraint Vs Trigger
Constraints will check for existing rows also
Triggers will not check for existing rows
Constraints provide standard error messages
Triggers provide user friendly error messages
Constraints provides pre-defined rules on table columns.
Triggers provides user-defined rules on table columns
* If constraint & Trigger are defined on table at a time only Trigger will be activated.
Advertising