602SQL Documentation Index  


statement_CREATE_TRIGGER ::= CREATE [ IF NOT EXISTS ] trigger_description;

The CREATE TRIGGER statement creates a new trigger according to the description. The table the trigger refers to must exist or a compiler error will occur.

The maximum length of a trigger name is 31 characters. Each trigger must have a unique name in the scheme context. If the specified trigger name already exists the error sqlstate 40004 (KEY_DUPLICITY) occurs.

You can also create a trigger from the Control Panel of the 602SQL Client.