15.00 - DROP TRIGGER - Teradata Database

Teradata Database SQL Data Definition Language Detailed Topics

Product
Teradata Database
Release Number
15.00
Content Type
Programming Reference
Publication ID
B035-1184-015K
Language
English (United States)

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.