16.20 - trigger_name - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Content Type
Programming Reference
Publication ID
B035-1144-162K
Language
English (United States)
Last Update
2019-05-24

Name of the trigger being created or replaced.

For information about naming database objects, see Teradata Vantage™ SQL Fundamentals, B035-1141.

A trigger_name must be unique within the database in which it is created.

database_name
An optional qualifier if the trigger is being created in a database other than the default for the current user.
ENABLED
Keyword that enables a trigger to execute.
ENABLED is the default.
DISABLED
Keyword that disables a trigger from executing.
The definition of a disabled trigger remains is not dropped, but it must be enabled before it can execute (see ALTER TRIGGER).
BEFORE
Specifies that the trigger performs before the triggering event, or triggering statement, is executed.
  • A BEFORE row trigger cannot have data-changing statements as triggered action SQL statements.
  • A BEFORE statement trigger is not valid under any circumstances.
Teradata Database returns an error message in both cases.
AFTER
The trigger performs after the triggering event.