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