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