DROP Processes for DROP TRIGGER
The system pursues the following process to drop a trigger:
1 Sets an EXCLUSIVE lock on the trigger.
2 Frees the disk space used by the dropped trigger and any fallback copy.
3 Removes any explicit access privileges on the object.
4 Removes the metadata for the dropped object from the data dictionary.