SQL/MX 3.x Reference Manual (H06.22+, J06.11+)

SQL/MX Statements

HP NonStop SQL/MX Reference Manual—640322-001

2-136

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-56.

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;