Constraints are used to maintain the integrity and atomicity of database .in other words it can be said they are used to prevent invalid data entry . the main 5 constraints are
NOT NULL,PRIMARY KEY,FOREIGN KEY,UNIQUE KEY and CHECK
Triggers are bascically stored procedures which automaticallly fired when any insert,update or delete is issued on table.
SOURCE : www.referjava.com
No comments:
Post a Comment