ALL_PART_KEY_COLUMNS v13
The following table lists the information available in the ALL_PART_KEY_COLUMNS view:
| Column | Type | Description |
|---|---|---|
owner | name | The name of the table owner. |
schema_name | name | The name of the schema on which the table resides. |
name | name | The name of the table. |
object_type | character(5) | This column will always be TABLE. |
column_name | name | The name of the partitioning key column. |
column_position | integer | The position of this column within the partitioning key (the first column has a column position of 1, the second column has a column position of 2...) |