The INFORMATION_SCHEMA PARTITIONS Table 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: The name of the catalog to which the table belongs. This value is always  def . The name of the schema (database) to which the table belongs. The name of the table containing the partition. The name of the partition. If the  PARTITIONS  table row represents a subpartition, the name of subpartition; otherwise  NULL . For  NDB : This value is always  NULL . 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. Subpartitions within a given partition are also indexed and reindexed in the same manner as partitions are indexed within a table. 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” . 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” . 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, 4805 • PARTITION_EXPRESSION • SUBPARTITION_METHOD • PARTITION_METHOD • SUBPARTITION_ORDINAL_POSITION • PARTITION_ORDINAL_POSITION • SUBPARTITION_NAME • PARTITION_NAME • TABLE_NAME • TABLE_SCHEMA • TABLE_CATALOG