triggerName

A triggerName refers to a trigger created by a user. To create a trigger, use the CREATE TRIGGER statement.

Syntax

[ schemaName . ] SQL92Identifier

You can qualify a trigger name with a schemaName. If a qualified trigger name is specified, the schema name cannot begin with SYS.

Example

DROP TRIGGER TRIG1