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

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

None