Drops the definition for the specified trigger from its subject table.
When you drop a trigger, the system:
- Sets an EXCLUSIVE lock on the trigger.
- Frees the disk space used by the dropped trigger and any fallback copy.
- Removes any explicit access privileges on the object.
- Removes the metadata for the dropped object from the data dictionary.
DROP TRIGGER is ANSI SQL:2011-compliant.
To drop a trigger, you must have DROP TRIGGER privilege on either the subject table of the trigger, or the database containing that table.