PARTITIONS Table
This page is part of MariaDB's Documentation.
The parent of this page is: Information Schema for MariaDB Enterprise Server
Topics on this page:
Overview
A description for this Information-schema Table has not yet been added to this Documentation.
USAGE
DETAILS
SYNONYMS
SCHEMA
CREATE TEMPORARY TABLE `PARTITIONS` (
`TABLE_CATALOG` varchar(512) NOT NULL,
`TABLE_SCHEMA` varchar(64) NOT NULL,
`TABLE_NAME` varchar(64) NOT NULL,
`PARTITION_NAME` varchar(64),
`SUBPARTITION_NAME` varchar(64),
`PARTITION_ORDINAL_POSITION` bigint(21) unsigned,
`SUBPARTITION_ORDINAL_POSITION` bigint(21) unsigned,
`PARTITION_METHOD` varchar(18),
`SUBPARTITION_METHOD` varchar(12),
`PARTITION_EXPRESSION` longtext,
`SUBPARTITION_EXPRESSION` longtext,
`PARTITION_DESCRIPTION` longtext,
`TABLE_ROWS` bigint(21) unsigned NOT NULL,
`AVG_ROW_LENGTH` bigint(21) unsigned NOT NULL,
`DATA_LENGTH` bigint(21) unsigned NOT NULL,
`MAX_DATA_LENGTH` bigint(21) unsigned,
`INDEX_LENGTH` bigint(21) unsigned NOT NULL,
`DATA_FREE` bigint(21) unsigned NOT NULL,
`CREATE_TIME` datetime,
`UPDATE_TIME` datetime,
`CHECK_TIME` datetime,
`CHECKSUM` bigint(21) unsigned,
`PARTITION_COMMENT` varchar(80) NOT NULL,
`NODEGROUP` varchar(12) NOT NULL,
`TABLESPACE_NAME` varchar(64)
)
PARAMETERS
SKYSQL
PRIVILEGES
EXAMPLES
ERROR HANDLING
FEATURE INTERACTION
RESPONSES
DIAGNOSIS
ISO 9075:2016
CHANGE HISTORY
Release Series | History |
---|---|
11.4 Enterprise |
|
10.6 Enterprise |
|
10.6 Community |
|
10.5 Enterprise |
|
10.5 Community |
|
10.4 Enterprise |
|
10.4 Community |
|
10.3 Enterprise |
|
10.3 Community |
|
10.2 Enterprise |
|
10.2 Community |
|
Release Series | History |
---|---|
11.4 Enterprise |
|
10.6 Enterprise |
|
10.5 Enterprise |
|
10.4 Enterprise |
|
RELATED TOPICS
EXTERNAL REFERENCES
Additional information on this topic may be found in the MariaDB Public Knowledge Base.