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 ;
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 ;