SQL Guide : solidDB® SQL statements : CREATE TRIGGER : Triggers usage notes and restrictions
  
Triggers usage notes and restrictions
To use the stored procedure that a trigger calls, provide the catalog, schema/owner and name of the table on which the trigger is defined and specify whether to enable or disable the triggers on the table.
To create a trigger on a table, you must have DBA authority or be the owner of the table on which the trigger is being defined.
You can define, by default, up to one trigger for each combination of table, action (INSERT, UPDATE, DELETE) and time (BEFORE and AFTER). This means there can be a maximum of six triggers per table.
Note The triggers are applied to each row. This means that if there are ten inserts, a trigger is executed ten times.
You cannot define triggers on a view (even if the view is based on a single table).
You cannot alter a table that has a trigger defined on it when the dependent columns are affected.
You cannot create a trigger on a system table.
You cannot execute triggers that reference dropped or altered objects. To prevent this error:
– Recreate any referenced object that you drop.
– Restore any referenced object you changed back to its original state (known by the trigger).
You can use reserved words in trigger statements if they are enclosed in double quotation marks. For example, the following CREATE TRIGGER statement references a column named “data” which is a reserved word.
"CREATE TRIGGER TRIG1 ON TMPT BEFORE INSERT
REFERENCING NEW "DATA" AS NEW_DATA
BEGIN
END"
Related information
See also
CREATE TRIGGER