PARTITIONS

Information on table partitions. The current authorization identifier must have the UTILITY privilege for the database or be the owner of the table.

Column name	Data type	Contents
PARTITION_CATALOG	CHAR (18)	Database name
TABLE_SCHEMA	CHAR (31)	Name of the schema to which the partitioned table belongs
TABLE_NAME	CHAR (31)	Name of the partitioned table
SERIAL_NUMBER	SMALLINT	Sequence number of the partition
MAX_KEY_VALUE	VARCHAR (32000)	Comparison for the upper partition boundary as specified in the VALUE clause (external presentation)
SPACE_NAME	CHAR (18)	Name of the space in which the partition is stored

Table 80: PARTITIONS view of the INFORMATION_SCHEMA