> For the complete documentation index, see [llms.txt](https://mariadb.com/docs/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://mariadb.com/docs/server/server-usage/partitioning-tables/partitions-metadata.md).

# Partitions Metadata

The [PARTITIONS](/docs/server/reference/system-tables/information-schema/information-schema-tables/information-schema-partitions-table.md) table in the [INFORMATION\_SCHEMA](/docs/server/reference/system-tables/information-schema.md) database contains information about partitions.

The [SHOW TABLE STATUS](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-table-status.md) statement contains a `Create_options` column, that contains the string 'partitioned' for partitioned tables.

The [SHOW CREATE TABLE](/docs/server/reference/sql-statements/administrative-sql-statements/show/show-create-table.md) statement returns the [CREATE TABLE](/docs/server/server-usage/tables/create-table.md) statement that can be used to re-create a table, including the partitions definition.

<sub>*This page is licensed: CC BY-SA / Gnu FDL*</sub>

{% @marketo/form formId="4316" %}