HELP CONSTRAINT Usage Notes - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
ft:locale
en-US
ft:lastEdition
2024-12-11
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905

HELP CONSTRAINT and Row-Level Security Constraints

The HELP CONSTRAINT statement is unrelated to the row-level security constraints that Teradata Row-Level Security uses. The statement does not report information for those constraints. For that information, use HELP SESSION and read the reports for the Constraint attribute.

HELP CONSTRAINT and Non-Updatable Views

You cannot run a HELP CONSTRAINT request against a non-updatable view.

Supported Named Constraint Types

There are three main types of named constraints:
  • CHECK
  • Referential
    • PRIMARY KEY
    • FOREIGN KEY
    • REFERENCES
  • UNIQUE