SQL Reference Guide

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