15.00 - DROP TRIGGER - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

prodname
Teradata Database
vrm_release
15.00
category
Programming Reference
featnum
B035-1184-015K

DROP TRIGGER

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.