The PARTITIONS table in the INFORMATION_SCHEMA database contains information about partitions.
The SHOW TABLE STATUS statement contains a Create_options column, that contains the string 'partitioned' for partitioned tables.
The SHOW CREATE TABLE statement returns the CREATE TABLE statement that can be used to re-create a table, including the partitions definition.
© 2019 MariaDB
Licensed under the Creative Commons Attribution 3.0 Unported License and the GNU Free Documentation License.
https://mariadb.com/kb/en/partitions-metadata/