Teradata Database Message 5859 - 5859 - Analytics Database - Teradata Vantage

Message

A triggered action statement or the WHEN clause cannot reference an Identity Column.

Explanation

The use of an Identity Column in a triggered action statement or the when clause can cause ambiguity when the trigger event is insert into a table with an Identity Column.

Generated By

Resolver

For Whom

End User.

Notes

None

Remedy

Redefine the trigger without referencing an Identity Column in the triggered action statement or the when clause.