ALL_SUBPART_KEY_COLUMNS v16
The following table lists the information available in the ALL_SUBPART_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 is always TABLE. |
column_name | name | The name of the partitioning key column. |
column_position | integer | The position of this column within the subpartitioning key (the first column has a column position of 1, the second column has a column position of 2...) |