MySQL 5.1 Database Reference Guide :: 23.19 The INFORMATION

23.19. The `INFORMATION_SCHEMA PARTITIONS` Table

$8.99

The PARTITIONS table provides information about table partitions.

`INFORMATION_SCHEMA` Name	`SHOW` Name	Remarks
`TABLE_CATALOG`		MySQL extension
`TABLE_SCHEMA`		MySQL extension
`TABLE_NAME`		MySQL extension
`PARTITION_NAME`		MySQL extension
`SUBPARTITION_NAME`		MySQL extension
`PARTITION_ORDINAL_POSITION`		MySQL extension
`SUBPARTITION_ORDINAL_POSITION`		MySQL extension
`PARTITION_METHOD`		MySQL extension
`SUBPARTITION_METHOD`		MySQL extension
`PARTITION_EXPRESSION`		MySQL extension
`SUBPARTITION_EXPRESSION`		MySQL extension
`PARTITION_DESCRIPTION`		MySQL extension
`TABLE_ROWS`		MySQL extension
`AVG_ROW_LENGTH`		MySQL extension
`DATA_LENGTH`		MySQL extension
`MAX_DATA_LENGTH`		MySQL extension
`INDEX_LENGTH`		MySQL extension
`DATA_FREE`		MySQL extension
`CREATE_TIME`		MySQL extension
`UPDATE_TIME`		MySQL extension
`CHECK_TIME`		MySQL extension
`CHECKSUM`		MySQL extension
`PARTITION_COMMENT`		MySQL extension
`NODEGROUP`		MySQL extension
`TABLESPACE_NAME`		MySQL extension

Notes:

The PARTITIONS table is a non-standard table. It was added in MySQL 5.1.6.
Important: If any partitioned tables created in a MySQL version prior to MySQL 5.1.6 are present following an upgrade to MySQL 5.1.6 or later, it is not possible to SELECT from, SHOW, or DESCRIBE the PARTITIONS table. See Section D.1.3, “Changes in release 5.1.6 (01 February 2006)” before upgrading from MySQL 5.1.5 or earlier to MySQL 5.1.6 or later.