The PARTITIONS  table provides information about table partitions. Each row in this table corresponds to an individual partition or subpartition of a partitioned table. For more information about partitioning tables, see Chapter 24, Partitioning . 

The PARTITIONS  table has these columns: 

• TABLE_CATALOG 

The name of the catalog to which the table belongs. This value is always def . 

• TABLE_SCHEMA 

The name of the schema (database) to which the table belongs. 

• TABLE_NAME 

The name of the table containing the partition. 

• PARTITION_NAME 

The name of the partition. 

• SUBPARTITION_NAME 

If the PARTITIONS  table row represents a subpartition, the name of subpartition; otherwise NULL . 

For NDB : This value is always NULL . 

• PARTITION_ORDINAL_POSITION 

All partitions are indexed in the same order as they are defined, with 1  being the number assigned to the first partition. The indexing can change as partitions are added, dropped, and reorganized; the number shown is this column reflects the current order, taking into account any indexing changes. 

• SUBPARTITION_ORDINAL_POSITION 

Subpartitions within a given partition are also indexed and reindexed in the same manner as partitions are indexed within a table. 

• PARTITION_METHOD 

One of the values RANGE , LIST , HASH , LINEAR HASH , KEY , or LINEAR KEY ; that is, one of the available partitioning types as discussed in Section 24.2, “Partitioning Types” . 

• SUBPARTITION_METHOD 

One of the values HASH , LINEAR HASH , KEY , or LINEAR KEY ; that is, one of the available subpartitioning types as discussed in Section 24.2.6, “Subpartitioning” . 

• PARTITION_EXPRESSION 

The expression for the partitioning function used in the CREATE TABLE  or ALTER TABLE  statement that created the table’s current partitioning scheme. 

For example, consider a partitioned table created in the test  database using this statement: 

CREATE TABLE tp ( c1 INT, c2 INT, 

