Icon DROP TRIGGER

Drops an existing trigger from a given table.

Syntax
DROP TRIGGER <Name> FROM <TableName>

Usage
Use this statement to drop a trigger from a table.

Examples
-- The following statement drops the UpdateNotes trigger.

DROP TRIGGER "UpdateNotes" FROM "Customer"

Required Privileges
The current user must be granted the DROP privilege on the specified table in order to execute this statement. Please see the User Security topic for more information.

SQL 2003 Standard Deviations
This statement deviates from the SQL 2003 standard in the following ways:

DeviationDetails
FROM ClauseThe FROM clause is an ElevateDB extension. Triggers are a table-level object in ElevateDB, whereas they are a schema-level object in the standard.
Image