USER_PART_TABLES¶
USER_PART_TABLES displays information about partitioned tables accessible to the current user.
Column | Type | Description |
---|---|---|
table_owner | character varying(64) | Name of the owner of the partitioned table |
schema | character varying(64) | Schema of the partitioned table |
table_name | character varying(64) | Name of the partitioned table |
partitioning_type | Text | Partition policy of the partitioned table Note Currently, only range partitioning and list partitioning are supported. |
partition_count | Bigint | Number of partitions of the partitioned table |
def_tablespace_name | Name | Tablespace name of the partitioned table |
partitioning_key_count | Integer | Number of partition keys of the partitioned table |