Triggers and Identity Columns - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™
The following rules and restrictions apply to triggers and INSERT operations into tables with identity columns.
  • You cannot create a trigger definition if its triggering statement is an INSERT on a subject table that has an identity column and its triggered action statement or WHEN condition references that column.
  • If a triggered statement makes row references to the table that is involved in the triggering statement, and the triggered statement is an INSERT operation into a table with a GENERATED ALWAYS identity column, Vantage substitutes a dummy value for the USING value for the referenced row and then generates the actual identity column number in the Dispatcher before sending it to its destination AMP.