The view information_schema.check_constraints contains all check constraints defined on a table.
SELECT * FROM information_schema.check_constraints;
information_schema.check_constraints
| column name | type | remarks |
|---|---|---|
| constraint_catalog | VARCHAR | Always NULL |
| constraint_schema | VARCHAR | |
| constraint_name | VARCHAR | |
| check_clause | VARCHAR |