apache > db
Apache DB Project
Font size:      

Trigger Action Overview

Trigger Action Overview

A trigger action is a simple SQL statement. For example:

DELETE FROM flightavailability 
    WHERE flight_id IN (SELECT flight_id FROM flightavailability 
        WHERE YEAR(flight_date) < 2004);) 

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 "TriggerAction" in the Derby Reference Manual for details.

Previous Page
Next Page
Table of Contents