HELP CONSTRAINT SQL Statement | VantageCloud Lake - HELP CONSTRAINT - 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

Displays the attributes for a specific named constraint on a table. Use the SHOW TABLE statement to get unnamed constraint information. See SHOW object Usage Notes.

The HELP CONSTRAINT statement does not report information for row-level security constraints. Specify the CONSTRAINT option with a HELP SESSION request to report the constraint values associated with a session.

ANSI Compliance

This statement is a Teradata extension to the ANSI SQL:2011 standard.

Required Privileges

You must own the table in which the constraint is defined or have at least one privilege on that table.

Use the SHOW privilege to enable a user to perform HELP or SHOW requests only against a specified constraint.