Knowledge Walls
John Peter
Pune, Maharashtra, India
`INFORMATION_SCHEMA`.`TABLES` in INFORMATION_SCHEMA Db of MySQL
1813 Views
TABLES Table of INFORMATION_SCHEMA Database 
TABLES contains all information about table of each database. It contains table_name, schema_name, created time, storage engine, charset and more.

Column Name Type Null
TABLE_CATALOG  varchar(512)  YES
TABLE_SCHEMA  varchar(64)  NO
TABLE_NAME  varchar(64)  NO
TABLE_TYPE  varchar(64)  NO
ENGINE  varchar(64)  YES
VERSION  bigint(21) unsigned  YES
ROW_FORMAT  varchar(10)  YES
TABLE_ROWS  bigint(21) unsigned  YES
AVG_ROW_LENGTH  bigint(21) unsigned  YES
DATA_LENGTH  bigint(21) unsigned  YES
MAX_DATA_LENGTH  bigint(21) unsigned  YES
INDEX_LENGTH  bigint(21) unsigned  YES
DATA_FREE  bigint(21) unsigned  YES
AUTO_INCREMENT  bigint(21) unsigned  YES
CREATE_TIME  datetime  YES
UPDATE_TIME  datetime  YES
CHECK_TIME  datetime  YES
TABLE_COLLATION  varchar(32)  YES
CHECKSUM  bigint(21) unsigned  YES
CREATE_OPTIONS  varchar(255)  YES
TABLE_COMMENT  varchar(80)  NO
Next Topics
Next lessons of current book.
INFORMATION_SCHEMA Db of MySQL
INFORMATION_SCHEMA Db of MySQL
Best Lessons of "MySQL"
Top lessons which are viewed more times.
  Copyright © 2014 Knowledge walls, All rights reserved
KnowledgeWalls
keep your tutorials and learnings with KnowledgeWalls. Don't lose your learnings hereafter. Save and revise it whenever required.
Click here for more details