2.19 DROP TRIGGER

---

Description

Deletes a trigger.

Syntax

DROP TRIGGER [ owner_name. ] trigger_name ;

Arguments

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