This statement removes a trigger from the current database.
Syntax
DROP TRIGGER [ IF EXISTS ] trigger-name
Remarks
The expression IF EXISTS causes the statement to return success instead of an error if a trigger does not exist. IF EXISTS does not suppress other errors.
Examples
The following example drops the trigger named InsTrig.