HELP CONSTRAINT SQL Statement | Teradata Vantage - 17.00 - HELP CONSTRAINT - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

Advanced SQL Engine
Teradata Database
Release Number
September 2020
Content Type
Programming Reference
Publication ID
English (United States)
Last Update

Displays the attributes for a specific named constraint on a table. Use the SHOW TABLE statement to obtain unnamed constraint information. See “SHOW object.”

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.


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.