Neoview SQL Reference Manual (R2.3)

DROP TRIGGER Statement
• “Syntax Description of DROP TRIGGER”
• “Considerations for DROP TRIGGER”
• “Examples of DROP TRIGGER”
The DROP TRIGGER statement is used to drop a trigger on an SQL table.
DROP TRIGGER trigger-name;
Syntax Description of DROP TRIGGER
trigger-name
specifies the name of the trigger to be dropped, of the form:
[[catalog-name.]schema-name.]trigger-name
where each part of the name is a valid SQL identifier with a maximum of 128 characters. For
information, see “Identifiers” (page 230).
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, owner of the schema, or be the services
ID.
Examples of DROP TRIGGER
• This example drops a trigger:
DROP TRIGGER my-trigger;
DROP TRIGGER Statement 101