17.10 - Dropping or Deleting Database Objects That Contain Triggers - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
Language
English (United States)

Vantage imposes restrictions on DROP and DELETE operations on the following database objects to ensure that triggers are not orphaned, as indicated by the following table:

IF you specify this statement … IN this state … THE result is …
DROP TABLE triggers are defined on the specified table an error message.

You must first drop all the triggers before the table can be dropped.

  • DELETE DATABASE
  • DELETE USER
at least one table in the named database or user is the subject table of triggers created in a different database an error message.

You must first drop all such triggers before the database or user can be deleted.