MySQL 8 Administrator???s Guide

Obtain partition information

Information about partitions can be obtained in a number of ways, as follows:

• The SHOW CREATE TABLE statement can be used to view the partition's schema information containing all partitioning clauses in the partitioned tables
• The SHOW TABLE STATUS statement can be used to check if the table is partitioned or not by viewing its status
• The EXPLAIN SELECT statement can be used to see partitions used by given SELECT option
• Using the INFORMATION_SCHEMA.PARTITIONS table for querying partition table information.

The following is an example with the SHOW CREATE TABLE statement option to see partition information:

SHOW CREATE TABLE employee;

The output from the preceding statement has separate information for partitioning ...