16.20 - Dropping or Deleting Database Objects That Contain Triggers - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Detailed Topics

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Release Date
March 2019
Content Type
Programming Reference
Publication ID
B035-1184-162K
Language
English (United States)

Teradata Database 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.