DROP TRIGGER

Remove the specified trigger.

Syntax

DROP TRIGGER trigger-name

Description

Removes the specified trigger.

Note: When a table is dropped, all triggers on that table are automatically dropped i.e. a table's triggers needn't be explicitly dropped before dropping the table