A. System Catalogs : Standard Catalog Interface : Standard Catalogs for All Databases : iidistschemes Catalog
 
Share this page                  
iidistschemes Catalog
The iidistschemes catalog describes the partitioning scheme of a partitioned table. Each partitioned table has one row per partitioning dimension in iidistschemes.
Column Name
Data Type
Description
table_name
char(256)
The name of the partitioned table
table_owner
char(32)
The owner of the table
dimension
smallint
The dimension being described, counting from 1
partitioning_columns
smallint
The number of columns that make up the partitioning value for a value-based partitioning rule
logical_partitions
smallint
The number of logical partitions in this dimension
partitioning_rule
varchar(9)
The partitioning rule:
AUTOMATIC
HASH
LIST
RANGE