Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions

  




 

 

23.19. The INFORMATION_SCHEMA PARTITIONS Table

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.


 
 
  Published under the terms of the GNU General Public License Design by Interspire