GaussDB-MY_CONSTRAINTS
MY_CONSTRAINTS displays table constraint information accessible to the current user. This view exists in the PG_CATALOG and SYS schemas.
| Name | Type | Description |
|---|---|---|
| constraint_name | character varying(64) | Constraint name. |
| constraint_type | text | Constraint type.- c: check constraint |
- f: foreign key constraint
- p: primary key constraint
- u: unique constraint | | table_name | character varying(64) | Name of a constraint-related table. | | index_owner | character varying(64) | Owner of a constraint-related index (only for the unique constraint and primary key constraint). | | index_name | character varying(64) | Name of a constraint-related index (only for the unique constraint and primary key constraint). | | owner | character varying(64) | Constraint creator. |
更多详情请参考GaussDB 文档中心：doc.hcs.huawei.com/db/zh-cn/ga…
