A. System Catalogs : Standard Catalog Interface : Standard Catalogs for All Databases : iidistcols Catalog
 
Share this page                  
iidistcols Catalog
The iidistcols catalog describes the columns that generate partitioning values for a partitioned table. Each partitioned table has one row per partitioning column per dimension in iidistcols. (Dimensions that do not use a value-based partitioning scheme do not appear in iidistcols.)
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
column_name
char(256)
The name of the partitioning column
column_sequence
smallint
The sequence of this column in this dimension's partitioning value, counting from 1
column_datatype
char(32)
The data type of the column.