PARTITIONCRITERIA System Table Description

Description

This table contains an entry for every table partition in each partitioned table in your Database.

Fields

Field Type Description

Field	Type	Description
SCHEMA	string	The schema in which this table exists.
TABLENAME	string	The name of the partitioned table.
PARTITIONNAME	string	The name of the partition in the table.
ISDEFAULT	integer	This is 1 if the partition is the default table partition for this table and 0 otherwise.
VALUE	string	This is the value for which any row where the partitioning column is less than this value will be inserted into the table partition specified by `PARTITIONNAME`. In the case of columns of type `TIMESTAMP`, `VALUE` is displayed in Coordinated Universal Time (UTC).

SCHEMA

string

The schema in which this table exists.

TABLENAME

string

The name of the partitioned table.

PARTITIONNAME

string

The name of the partition in the table.

ISDEFAULT

integer

This is 1 if the partition is the default table partition for this table and 0 otherwise.

VALUE

string

This is the value for which any row where the partitioning column is less than this value will be inserted into the table partition specified by PARTITIONNAME. In the case of columns of type TIMESTAMP, VALUE is displayed in Coordinated Universal Time (UTC).

Indexes

Secondary Index: PARTITIONCRITERIAIDX on fields: TABLENAME, SCHEMA, PARTITIONNAME