Trigger action overview

A trigger action is a simple SQL statement.

For example:

CREATE TRIGGER . . .
DELETE FROM FlightAvailability 
  WHERE flight_id IN (SELECT flight_id FROM FlightAvailability 
    WHERE YEAR(flight_date) < 2005);

A trigger action does have some limitations, though; for example, it cannot contain dynamic parameters or alter the table on which the trigger is defined. See the "Triggered-SQL-statement" section of the "CREATE TRIGGER statement" topic in the Derby Reference Manual for details.