DROP TRIGGER

Function

DROP TRIGGER deletes a trigger.

Precautions

The owner of the table where a trigger resides or a user granted the DROP ANY TRIGGER permission can perform the DROP TRIGGER operation. The system administrator has this permission by default.

Syntax

DropTrigger ::= DROP TRIGGER [ IF EXISTS ] trigger_name ON table_name [ CASCADE | RESTRICT ];

Parameter Description

• IF EXISTS

  Reports a notice instead of an error if the specified trigger does not exist.

• trigger_name

  Specifies the name of the trigger to be deleted.

  Value range: an existing trigger name

• table_name

  Specifies the name of the table containing the trigger.

  Value range: name of the table containing the trigger

• CASCADE | RESTRICT

  • CASCADE: automatically deletes the objects that depend on the trigger.
  • RESTRICT: refuses to delete the trigger if any objects depend on it. This is the default action.

Examples

For details, see Examples in CREATE TRIGGER.

Helpful Links

CREATE TRIGGER, ALTER TRIGGER, and ALTER TABLE