ADM_PART_TABLES

ADM_PART_TABLES displays information about all partitioned tables in the database. By default, only the system administrator can access this view. Common users can access the view only after being authorized. This view exists in both PG_CATALOG and SYS schema.

**Table 1** ADM_PART_TABLES columns
Name	Type	Description
table_owner	character varying(64)	Owner name of a partitioned table
table_name	character varying(64)	Name of a partitioned table
partitioning_type	text	Partitioning policy of a partitioned table NOTE: For details about the supported partitioning policies of the current partitioned table, see CREATE TABLE PARTITION.
partition_count	bigint	Number of partitions of a partitioned table
partitioning_key_count	integer	Number of partition keys of a partitioned table
def_tablespace_name	name	Tablespace name of a partitioned table
schema	character varying(64)	Schema of a partitioned table
subpartitioning_type	text	Partitioning policy of a level-2 partitioned table. If the partitioned table is a level-1 partitioned table, NONE is displayed. NOTE: For details about the supported partitioning policies of the current level-2 partitioned table, see CREATE TABLE SUBPARTITION.
def_subpartition_count	integer	Default number of level-2 partitions to be created. The value is 1 for a level-2 partitioned table and 0 for a level-1 partitioned table.
subpartitioning_key_count	integer	Number of level-2 partition keys of the partitioned table.