Trigger

  • A trigger is a SQL procedure that initiates an action when an event (INSERT, DELETE or UPDATE) occurs.
  • Triggers are stored in and managed by the DBMS.
  • Triggers are used to maintain the referential integrity of data by changing the data in a systematic fashion.
  • A trigger cannot be called or executed; the DBMS automatically fires the trigger as a result of a data modification to the associated table.

0 comments :

Post a Comment

> Related Posts with Thumbnails
 

Copyright © 2012. GS dot net - All Rights Reserved - Design by BTDesigner - Proudly powered by Blogger