Neoview SQL Reference Manual (R2.4)

DROP TRIGGER Statement
• “Syntax Description of DROP TRIGGER”
• “Considerations for DROP TRIGGER”
• “Example of DROP TRIGGER”
The DROP TRIGGER statement is used to drop a trigger on an SQL table. See “Triggers” (page 291).
DROP TRIGGER trigger-name;
Syntax Description of DROP TRIGGER
trigger-name
specifies the name of the trigger to be dropped. For naming convention, see “Database Objects”
(page 227).
Considerations for DROP TRIGGER
If you use the CASCADE option to drop objects (table, view, or column) used by a trigger, the
triggers using that object will also be dropped.
Authorization and Availability Requirements
To drop a trigger, you must be the owner of the trigger or owner of the schema.
Example of DROP TRIGGER
• This example drops a trigger:
DROP TRIGGER my-trigger;
DROP TRIGGER Statement 115