SQL-Browser

[Tools]  Database: `information_schema`  Table: `COLUMNS`

   show less  show more             Upload SQL file   Search   MySQl Documentation
The execution of SQL Statements can manipulate data. TAKE CARE! The Authors don't accept any liability for damaged or lost data.

Data View

new record    Edit table structure

Table `information_schema`.`COLUMNS`
records 1 - 30 from totally 608    <<    <    >    >>

View: compact   The Query contains 19 Columns
 # TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT   [BB] IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE   [BB] COLUMN_KEY EXTRA PRIVILEGES COLUMN_COMMENT
  edit delete1. 
def
information_schema
CHARACTER_SETS
CHARACTER_SET_NAME
1
NO
varchar
32
96
NULL
NULL
utf8
utf8_general_ci
varchar(32)
select
  edit delete2. 
def
information_schema
CHARACTER_SETS
DEFAULT_COLLATE_NAME
2
NO
varchar
32
96
NULL
NULL
utf8
utf8_general_ci
varchar(32)
select
  edit delete3. 
def
information_schema
CHARACTER_SETS
DESCRIPTION
3
NO
varchar
60
180
NULL
NULL
utf8
utf8_general_ci
varchar(60)
select
  edit delete4. 
def
information_schema
CHARACTER_SETS
MAXLEN
4
0
NO
bigint
NULL
NULL
19
0
NULL
NULL
bigint(3)
select
  edit delete5. 
def
information_schema
COLLATIONS
COLLATION_NAME
1
NO
varchar
32
96
NULL
NULL
utf8
utf8_general_ci
varchar(32)
select
  edit delete6. 
def
information_schema
COLLATIONS
CHARACTER_SET_NAME
2
NO
varchar
32
96
NULL
NULL
utf8
utf8_general_ci
varchar(32)
select
  edit delete7. 
def
information_schema
COLLATIONS
ID
3
0
NO
bigint
NULL
NULL
19
0
NULL
NULL
bigint(11)
select
  edit delete8. 
def
information_schema
COLLATIONS
IS_DEFAULT
4
NO
varchar
3
9
NULL
NULL
utf8
utf8_general_ci
varchar(3)
select
  edit delete9. 
def
information_schema
COLLATIONS
IS_COMPILED
5
NO
varchar
3
9
NULL
NULL
utf8
utf8_general_ci
varchar(3)
select
  edit delete10. 
def
information_schema
COLLATIONS
SORTLEN
6
0
NO
bigint
NULL
NULL
19
0
NULL
NULL
bigint(3)
select
  edit delete11. 
def
information_schema
COLLATION_CHARACTER_SET_APPLICABILITY
COLLATION_NAME
1
NO
varchar
32
96
NULL
NULL
utf8
utf8_general_ci
varchar(32)
select
  edit delete12. 
def
information_schema
COLLATION_CHARACTER_SET_APPLICABILITY
CHARACTER_SET_NAME
2
NO
varchar
32
96
NULL
NULL
utf8
utf8_general_ci
varchar(32)
select
  edit delete13. 
def
information_schema
COLUMNS
TABLE_CATALOG
1
NO
varchar
512
1536
NULL
NULL
utf8
utf8_general_ci
varchar(512)
select
  edit delete14. 
def
information_schema
COLUMNS
TABLE_SCHEMA
2
NO
varchar
64
192
NULL
NULL
utf8
utf8_general_ci
varchar(64)
select
  edit delete15. 
def
information_schema
COLUMNS
TABLE_NAME
3
NO
varchar
64
192
NULL
NULL
utf8
utf8_general_ci
varchar(64)
select
  edit delete16. 
def
information_schema
COLUMNS
COLUMN_NAME
4
NO
varchar
64
192
NULL
NULL
utf8
utf8_general_ci
varchar(64)
select
  edit delete17. 
def
information_schema
COLUMNS
ORDINAL_POSITION
5
0
NO
bigint
NULL
NULL
20
0
NULL
NULL
bigint(21) unsigned
select
  edit delete18. 
def
information_schema
COLUMNS
COLUMN_DEFAULT
6
NULL
YES
longtext
4294967295
4294967295
NULL
NULL
utf8
utf8_general_ci
longtext
select
  edit delete19. 
def
information_schema
COLUMNS
IS_NULLABLE
7
NO
varchar
3
9
NULL
NULL
utf8
utf8_general_ci
varchar(3)
select
  edit delete20. 
def
information_schema
COLUMNS
DATA_TYPE
8
NO
varchar
64
192
NULL
NULL
utf8
utf8_general_ci
varchar(64)
select
  edit delete21. 
def
information_schema
COLUMNS
CHARACTER_MAXIMUM_LENGTH
9
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
bigint(21) unsigned
select
  edit delete22. 
def
information_schema
COLUMNS
CHARACTER_OCTET_LENGTH
10
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
bigint(21) unsigned
select
  edit delete23. 
def
information_schema
COLUMNS
NUMERIC_PRECISION
11
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
bigint(21) unsigned
select
  edit delete24. 
def
information_schema
COLUMNS
NUMERIC_SCALE
12
NULL
YES
bigint
NULL
NULL
20
0
NULL
NULL
bigint(21) unsigned
select
  edit delete25. 
def
information_schema
COLUMNS
CHARACTER_SET_NAME
13
NULL
YES
varchar
32
96
NULL
NULL
utf8
utf8_general_ci
varchar(32)
select
  edit delete26. 
def
information_schema
COLUMNS
COLLATION_NAME
14
NULL
YES
varchar
32
96
NULL
NULL
utf8
utf8_general_ci
varchar(32)
select
  edit delete27. 
def
information_schema
COLUMNS
COLUMN_TYPE
15
NULL
NO
longtext
4294967295
4294967295
NULL
NULL
utf8
utf8_general_ci
longtext
select
  edit delete28. 
def
information_schema
COLUMNS
COLUMN_KEY
16
NO
varchar
3
9
NULL
NULL
utf8
utf8_general_ci
varchar(3)
select
  edit delete29. 
def
information_schema
COLUMNS
EXTRA
17
NO
varchar
27
81
NULL
NULL
utf8
utf8_general_ci
varchar(27)
select
  edit delete30. 
def
information_schema
COLUMNS
PRIVILEGES
18
NO
varchar
80
240
NULL
NULL
utf8
utf8_general_ci
varchar(80)
select

records 1 - 30 from totally 608    <<    <    >    >>