Help Center/ Data Warehouse Service/ Standard Data Warehouse (9.1.0.x)/ DWS System Catalogs and Views/ System Views/ USER_PART_TABLES
Updated on 2025-10-09 GMT+08:00
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 |
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.
