MY_CONSTRAINTS
MY_CONSTRAINTS displays table constraint information accessible to the current user. This view exists in both PG_CATALOG and SYS schema.
Name |
Type |
Description |
---|---|---|
owner |
character varyiny(64) |
Constraint creator. |
constraint_name |
vcharacter varying(64) |
Constraint name. |
constraint_type |
text |
Constraint type.
|
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 the constraint-related index (only for the unique constraint and primary key constraint). |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.