USER_CONSTRAINTS
USER_CONSTRAINTS displays the table constraint information accessible to the current user.
Name |
Type |
Description |
---|---|---|
constraint_name |
vcharacter varying(64) |
Constraint name |
constraint_type |
text |
Constraint type
|
table_name |
character varying(64) |
Name of constraint-related table |
index_owner |
character varying(64) |
Owner of constraint-related index (only for the unique constraint and primary key constraint) |
index_name |
character varying(64) |
Name of constraint-related index (only for the unique constraint and primary key constraint) |
Example
Query constraints on a specified table owned by the current user. Replace t1 with the actual table name.
1 2 3 4 5 |
SELECT * FROM USER_CONSTRAINTS WHERE table_name='t1'; constraint_name | constraint_type | table_name | index_owner | index_name -----------------+-----------------+------------+-------------+--------------- c_custkey_key | p | t1 | u1 | c_custkey_key (1 row) |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot