DROP TRIGGER statement 

A DROP TABLE statement deletes a trigger for a table.

Syntax

<drop trigger statement> ::= DROP TRIGGER <trigger name> OF <table name>

trigger name, table name

Explanation

The specified table name must identify an existing table of the current user.

The specified trigger name must identify an existing trigger of the table.

The metadata of the trigger is dropped.