SQL/MX 2.x Reference Manual (H06.04+)

SQL/MX Statements
HP NonStop SQL/MX Reference Manual—540440-003
2-129
DROP TRIGGER Statement
DROP TRIGGER Statement
Considerations for DROP TRIGGER
Examples of DROP TRIGGER
The DROP TRIGGER statement is used to drop a trigger on an SQL/MX table.
Syntax Description of DROP TRIGGER
trigger-name
specifies the ANSI logical 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 more information, see Identifiers on page 6-52.
Considerations for DROP TRIGGER
You can drop an object (table, view, or column) used by a trigger if you use the
CASCADE option.
Authorization and Availability Requirements
To drop a trigger, you must own its schema or be the super ID.
Examples of DROP TRIGGER
•
This example drops a trigger:
DROP TRIGGER my-trigger;
DROP TRIGGER trigger-name;