Neoview SQL Reference Manual (R2.5)

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 311).
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 Object
Names” (page 242).
Considerations for DROP TRIGGER
If you use the CASCADE option to drop objects (table or view) used by a trigger, the triggers
using that object will also be dropped.
Authorization 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 119