Investigating Security Constraint Object Definitions - Advanced SQL Engine - Teradata Database

Users with the CONSTRAINT ASSIGNMENT or CONSTRAINT DEFINITION privilege can use the SHOW CONSTRAINT statement to display the SQL DDL syntax that defines a CONSTRAINT object, for example:

SHOW CONSTRAINT  constraint_name  ;