Product Documentation

SQL Reference Guide

Previous Topic

Next Topic

DROP TRIGGER

Description

Deletes a trigger.

Syntax

DROP TRIGGER [IF EXISTS] [ owner_name. ] trigger_name ;

Arguments

IF EXISTS

This argument avoids failure by attempting to drop the trigger only if a trigger of that name already exists.

owner_name

Specifies the owner of the trigger.

trigger_name

Names of the trigger to delete.

Example

DROP TRIGGER sal_check ;

Authorization

  • The DBA privilege entitles a user to drop any trigger.
  • The owner of a trigger is given EXECUTE and DROP privilege on that trigger at creation time, by default.

    SQL Compliance

    SQL-93, ODBC Core SQL grammar

    Environment

    Embedded SQL, interactive SQL, ODBC applications

    Related Statements

    CREATE TRIGGER

TOCIndex