Assigning a Trigger Name

The trigger name identifies the trigger, and must be unique within the database. The trigger name follows the words CREATE TRIGGER in the statement. It can be up to 18 bytes in length, beginning with a letter and consisting of letters, the digits 0 to 9, and the underscore. In the following example, the portion of the CREATE TRIGGER statement that is shown assigns the name upqty to the trigger:

CREATE TRIGGER upqty       -- assign trigger name