ADM_CONS_COLUMNS
ADM_CONS_COLUMNS displays information about constraint columns in database tables. By default, only users with the SYSADMIN permission can access this system view. Common users can access it only after being authorized. This view exists in both PG_CATALOG and SYS schemas.
Name |
Type |
Description |
---|---|---|
owner |
character varying(64) |
Constraint creator. |
column_name |
character varying(64) |
Name of a constraint-related column. |
constraint_name |
character varying(64) |
Constraint name. |
position |
smallint |
Position of a column in a table. |
table_name |
character varying(64) |
Name of a constraint-related table. |
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