DROP TRIGGER SQL Statement | Teradata Vantage - 17.05 - DROP TRIGGER - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
January 2021
Content Type
Programming Reference
Publication ID
English (United States)

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.

ANSI Compliance

DROP TRIGGER is ANSI SQL:2011-compliant.

Required Privileges

To drop a trigger, you must have DROP TRIGGER privilege on either the subject table of the trigger, or the database containing that table.