Knowledge Walls
John Peter
Pune, Maharashtra, India
`INFORMATION_SCHEMA`.`COLUMNS` in INFORMATION_SCHEMA Db of MySQL
2000 Views
COLUMNS TABLE 
COLUMNS table contains column information of all tables and schema. Below details are available in the information_schema columns table.

Column Name Type Null
TABLE_CATALOG  varchar(512)  YES
TABLE_SCHEMA  varchar(64)  NO
TABLE_NAME  varchar(64)  NO
COLUMN_NAME  varchar(64)  NO
ORDINAL_POSITION  bigint(21) unsigned  NO
COLUMN_DEFAULT  longtext  YES
IS_NULLABLE  varchar(3)  NO
DATA_TYPE  varchar(64)  NO
CHARACTER_MAXIMUM_LENGTH  bigint(21) unsigned  YES
CHARACTER_OCTET_LENGTH  bigint(21) unsigned  YES
NUMERIC_PRECISION  bigint(21) unsigned  YES
NUMERIC_SCALE  bigint(21) unsigned  YES
CHARACTER_SET_NAME  varchar(32)  YES
COLLATION_NAME  varchar(32)  YES
COLUMN_TYPE  longtext  NO
COLUMN_KEY  varchar(3)  NO
EXTRA  varchar(27)  NO
PRIVILEGES  varchar(80)  NO
COLUMN_COMMENT  varchar(255)  NO
COLUMNS TABLE 
COLUMNS table contains column information of all tables and schema. Below details are available in the information_schema columns table.

Column Name Type Null
TABLE_CATALOG  varchar(512)  YES
TABLE_SCHEMA  varchar(64)  NO
TABLE_NAME  varchar(64)  NO
COLUMN_NAME  varchar(64)  NO
ORDINAL_POSITION  bigint(21) unsigned  NO
COLUMN_DEFAULT  longtext  YES
IS_NULLABLE  varchar(3)  NO
DATA_TYPE  varchar(64)  NO
CHARACTER_MAXIMUM_LENGTH  bigint(21) unsigned  YES
CHARACTER_OCTET_LENGTH  bigint(21) unsigned  YES
NUMERIC_PRECISION  bigint(21) unsigned  YES
NUMERIC_SCALE  bigint(21) unsigned  YES
CHARACTER_SET_NAME  varchar(32)  YES
COLLATION_NAME  varchar(32)  YES
COLUMN_TYPE  longtext  NO
COLUMN_KEY  varchar(3)  NO
EXTRA  varchar(27)  NO
PRIVILEGES  varchar(80)  NO
COLUMN_COMMENT  varchar(255)  NO
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