triggers & integrity constraints

Published on by LakshmiSaahul,Dhana Royal

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
To be informed of the latest articles, subscribe:
Comment on this post