USER_PART_KEY_COLUMNS v11
The USER_PART_KEY_COLUMNS view provides information about the key columns of the partitioned tables that reside in the database.
| Name | Type | Description |
|---|---|---|
schema_name | TEXT | The name of the schema in which the table resides. |
name | TEXT | The name of the table in which the column resides. |
object_type | CHARACTER(5) | For compatibility only; always TABLE. |
column_name | TEXT | The name of the column on which the key is defined. |
column_position | INTEGER | 1 for the first column; 2 for the second column, etc. |