SQL/MX 2.x Reference Manual (G06.24+, H06.03+)

SQL/MX Statements

HP NonStop SQL/MX Reference Manual—523725-004

2-132

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 information, see Identifiers on page 6-54.

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;