Informix Guide to SQL: Syntax SQL Statements

Use the DROP TRIGGER statement to remove a trigger definition from a database.

You must be the owner of the trigger or have the DBA privilege to drop the trigger.

Dropping a trigger removes the text of the trigger definition and the executable trigger from the database.

The following statement drops the items_pct trigger:

DROP TRIGGER items_pct

If a DROP TRIGGER statement appears inside an SPL routine that is called by a data manipulation statement, the database server returns an error.

Related statements: CREATE TRIGGER