Entering content frame

This graphic is explained in the accompanying text TRIGGERS Locate the document in the library structure

Prerequisites

You have generated the Structure linkdemo data for the SQL Tutorial.

Log on to the demo database instance DEMODB as user MONA.

Define triggers. Proceed as described in SQL Tutorial, Structure linkDatabase Triggers.

Examples

You can use the system table TRIGGERS to determine the following database information, among other things:

     Update trigger for the HOTEL table

SELECT triggername, definition
  FROM DOMAIN.TRIGGERS
    WHERE tablename = 'HOTEL'
      AND UPDATE = 'YES'

     Table and action for which the trigger HOTEL_UPDATE was defined

SELECT owner, triggername, insert, update, delete
  FROM DOMAIN.TRIGGERS
    WHERE triggername = 'HOTEL_UPDATE'

 

Leaving content frame