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