Help Center/ GaussDB/ Developer Guide(Distributed_V2.0-2.x)/ System Catalogs and System Views/ System Views/ MY_CONS_COLUMNS
Updated on 2025-08-19 GMT+08:00
MY_CONS_COLUMNS
MY_CONS_COLUMNS displays information about primary key constraint columns in tables accessible to the current user. This view exists in both PG_CATALOG and SYS schema.
| Name | Type | Description |
|---|---|---|
| owner | character varying(64) | Constraint creator. |
| table_name | character varying(64) | Name of a constraint-related table. |
| 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. |
Parent topic: System Views
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
The system is busy. Please try again later.
