Detalhes da Tabela

COLUMNS | Database: information_schema | Conexão: Teste migração

Estrutura da Tabela

Field Type Null Key Default Extra
TABLE_CATALOG varchar(512) NO
TABLE_SCHEMA varchar(64) NO
TABLE_NAME varchar(64) NO
COLUMN_NAME varchar(64) NO
ORDINAL_POSITION bigint(21) unsigned NO 0
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
DATETIME_PRECISION 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(30) NO
PRIVILEGES varchar(80) NO
COLUMN_COMMENT varchar(1024) NO
GENERATION_EXPRESSION longtext NO

Dados da Tabela (máx. 100 linhas)

TABLE_CATALOG TABLE_SCHEMA TABLE_NAME COLUMN_NAME ORDINAL_POSITION COLUMN_DEFAULT IS_NULLABLE DATA_TYPE CHARACTER_MAXIMUM_LENGTH CHARACTER_OCTET_LENGTH NUMERIC_PRECISION NUMERIC_SCALE DATETIME_PRECISION CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE COLUMN_KEY EXTRA PRIVILEGES COLUMN_COMMENT GENERATION_EXPRESSION
def information_schema CHARACTER_SETS CHARACTER_SET_NAME 1 NO varchar 32 96 utf8 utf8_general_ci varchar(32) select
def information_schema CHARACTER_SETS DEFAULT_COLLATE_NAME 2 NO varchar 32 96 utf8 utf8_general_ci varchar(32) select
def information_schema CHARACTER_SETS DESCRIPTION 3 NO varchar 60 180 utf8 utf8_general_ci varchar(60) select
def information_schema CHARACTER_SETS MAXLEN 4 0 NO bigint 19 0 bigint(3) select
def information_schema COLLATIONS COLLATION_NAME 1 NO varchar 32 96 utf8 utf8_general_ci varchar(32) select
def information_schema COLLATIONS CHARACTER_SET_NAME 2 NO varchar 32 96 utf8 utf8_general_ci varchar(32) select
def information_schema COLLATIONS ID 3 0 NO bigint 19 0 bigint(11) select
def information_schema COLLATIONS IS_DEFAULT 4 NO varchar 3 9 utf8 utf8_general_ci varchar(3) select
def information_schema COLLATIONS IS_COMPILED 5 NO varchar 3 9 utf8 utf8_general_ci varchar(3) select
def information_schema COLLATIONS SORTLEN 6 0 NO bigint 19 0 bigint(3) select
def information_schema COLLATION_CHARACTER_SET_APPLICABILITY COLLATION_NAME 1 NO varchar 32 96 utf8 utf8_general_ci varchar(32) select
def information_schema COLLATION_CHARACTER_SET_APPLICABILITY CHARACTER_SET_NAME 2 NO varchar 32 96 utf8 utf8_general_ci varchar(32) select
def information_schema COLUMNS TABLE_CATALOG 1 NO varchar 512 1536 utf8 utf8_general_ci varchar(512) select
def information_schema COLUMNS TABLE_SCHEMA 2 NO varchar 64 192 utf8 utf8_general_ci varchar(64) select
def information_schema COLUMNS TABLE_NAME 3 NO varchar 64 192 utf8 utf8_general_ci varchar(64) select
def information_schema COLUMNS COLUMN_NAME 4 NO varchar 64 192 utf8 utf8_general_ci varchar(64) select
def information_schema COLUMNS ORDINAL_POSITION 5 0 NO bigint 20 0 bigint(21) unsigned select
def information_schema COLUMNS COLUMN_DEFAULT 6 YES longtext 4294967295 4294967295 utf8 utf8_general_ci longtext select
def information_schema COLUMNS IS_NULLABLE 7 NO varchar 3 9 utf8 utf8_general_ci varchar(3) select
def information_schema COLUMNS DATA_TYPE 8 NO varchar 64 192 utf8 utf8_general_ci varchar(64) select
def information_schema COLUMNS CHARACTER_MAXIMUM_LENGTH 9 YES bigint 20 0 bigint(21) unsigned select
def information_schema COLUMNS CHARACTER_OCTET_LENGTH 10 YES bigint 20 0 bigint(21) unsigned select
def information_schema COLUMNS NUMERIC_PRECISION 11 YES bigint 20 0 bigint(21) unsigned select
def information_schema COLUMNS NUMERIC_SCALE 12 YES bigint 20 0 bigint(21) unsigned select
def information_schema COLUMNS DATETIME_PRECISION 13 YES bigint 20 0 bigint(21) unsigned select
def information_schema COLUMNS CHARACTER_SET_NAME 14 YES varchar 32 96 utf8 utf8_general_ci varchar(32) select
def information_schema COLUMNS COLLATION_NAME 15 YES varchar 32 96 utf8 utf8_general_ci varchar(32) select
def information_schema COLUMNS COLUMN_TYPE 16 NO longtext 4294967295 4294967295 utf8 utf8_general_ci longtext select
def information_schema COLUMNS COLUMN_KEY 17 NO varchar 3 9 utf8 utf8_general_ci varchar(3) select
def information_schema COLUMNS EXTRA 18 NO varchar 30 90 utf8 utf8_general_ci varchar(30) select
def information_schema COLUMNS PRIVILEGES 19 NO varchar 80 240 utf8 utf8_general_ci varchar(80) select
def information_schema COLUMNS COLUMN_COMMENT 20 NO varchar 1024 3072 utf8 utf8_general_ci varchar(1024) select
def information_schema COLUMNS GENERATION_EXPRESSION 21 NO longtext 4294967295 4294967295 utf8 utf8_general_ci longtext select
def information_schema COLUMN_PRIVILEGES GRANTEE 1 NO varchar 81 243 utf8 utf8_general_ci varchar(81) select
def information_schema COLUMN_PRIVILEGES TABLE_CATALOG 2 NO varchar 512 1536 utf8 utf8_general_ci varchar(512) select
def information_schema COLUMN_PRIVILEGES TABLE_SCHEMA 3 NO varchar 64 192 utf8 utf8_general_ci varchar(64) select
def information_schema COLUMN_PRIVILEGES TABLE_NAME 4 NO varchar 64 192 utf8 utf8_general_ci varchar(64) select
def information_schema COLUMN_PRIVILEGES COLUMN_NAME 5 NO varchar 64 192 utf8 utf8_general_ci varchar(64) select
def information_schema COLUMN_PRIVILEGES PRIVILEGE_TYPE 6 NO varchar 64 192 utf8 utf8_general_ci varchar(64) select
def information_schema COLUMN_PRIVILEGES IS_GRANTABLE 7 NO varchar 3 9 utf8 utf8_general_ci varchar(3) select
def information_schema ENGINES ENGINE 1 NO varchar 64 192 utf8 utf8_general_ci varchar(64) select
def information_schema ENGINES SUPPORT 2 NO varchar 8 24 utf8 utf8_general_ci varchar(8) select
def information_schema ENGINES COMMENT 3 NO varchar 80 240 utf8 utf8_general_ci varchar(80) select
def information_schema ENGINES TRANSACTIONS 4 YES varchar 3 9 utf8 utf8_general_ci varchar(3) select
def information_schema ENGINES XA 5 YES varchar 3 9 utf8 utf8_general_ci varchar(3) select
def information_schema ENGINES SAVEPOINTS 6 YES varchar 3 9 utf8 utf8_general_ci varchar(3) select
def information_schema EVENTS EVENT_CATALOG 1 NO varchar 64 192 utf8 utf8_general_ci varchar(64) select
def information_schema EVENTS EVENT_SCHEMA 2 NO varchar 64 192 utf8 utf8_general_ci varchar(64) select
def information_schema EVENTS EVENT_NAME 3 NO varchar 64 192 utf8 utf8_general_ci varchar(64) select
def information_schema EVENTS DEFINER 4 NO varchar 93 279 utf8 utf8_general_ci varchar(93) select
def information_schema EVENTS TIME_ZONE 5 NO varchar 64 192 utf8 utf8_general_ci varchar(64) select
def information_schema EVENTS EVENT_BODY 6 NO varchar 8 24 utf8 utf8_general_ci varchar(8) select
def information_schema EVENTS EVENT_DEFINITION 7 NO longtext 4294967295 4294967295 utf8 utf8_general_ci longtext select
def information_schema EVENTS EVENT_TYPE 8 NO varchar 9 27 utf8 utf8_general_ci varchar(9) select
def information_schema EVENTS EXECUTE_AT 9 YES datetime 0 datetime select
def information_schema EVENTS INTERVAL_VALUE 10 YES varchar 256 768 utf8 utf8_general_ci varchar(256) select
def information_schema EVENTS INTERVAL_FIELD 11 YES varchar 18 54 utf8 utf8_general_ci varchar(18) select
def information_schema EVENTS SQL_MODE 12 NO varchar 8192 24576 utf8 utf8_general_ci varchar(8192) select
def information_schema EVENTS STARTS 13 YES datetime 0 datetime select
def information_schema EVENTS ENDS 14 YES datetime 0 datetime select
def information_schema EVENTS STATUS 15 NO varchar 18 54 utf8 utf8_general_ci varchar(18) select
def information_schema EVENTS ON_COMPLETION 16 NO varchar 12 36 utf8 utf8_general_ci varchar(12) select
def information_schema EVENTS CREATED 17 0000-00-00 00:00:00 NO datetime 0 datetime select
def information_schema EVENTS LAST_ALTERED 18 0000-00-00 00:00:00 NO datetime 0 datetime select
def information_schema EVENTS LAST_EXECUTED 19 YES datetime 0 datetime select
def information_schema EVENTS EVENT_COMMENT 20 NO varchar 64 192 utf8 utf8_general_ci varchar(64) select
def information_schema EVENTS ORIGINATOR 21 0 NO bigint 19 0 bigint(10) select
def information_schema EVENTS CHARACTER_SET_CLIENT 22 NO varchar 32 96 utf8 utf8_general_ci varchar(32) select
def information_schema EVENTS COLLATION_CONNECTION 23 NO varchar 32 96 utf8 utf8_general_ci varchar(32) select
def information_schema EVENTS DATABASE_COLLATION 24 NO varchar 32 96 utf8 utf8_general_ci varchar(32) select
def information_schema FILES FILE_ID 1 0 NO bigint 19 0 bigint(4) select
def information_schema FILES FILE_NAME 2 YES varchar 4000 12000 utf8 utf8_general_ci varchar(4000) select
def information_schema FILES FILE_TYPE 3 NO varchar 20 60 utf8 utf8_general_ci varchar(20) select
def information_schema FILES TABLESPACE_NAME 4 YES varchar 64 192 utf8 utf8_general_ci varchar(64) select
def information_schema FILES TABLE_CATALOG 5 NO varchar 64 192 utf8 utf8_general_ci varchar(64) select
def information_schema FILES TABLE_SCHEMA 6 YES varchar 64 192 utf8 utf8_general_ci varchar(64) select
def information_schema FILES TABLE_NAME 7 YES varchar 64 192 utf8 utf8_general_ci varchar(64) select
def information_schema FILES LOGFILE_GROUP_NAME 8 YES varchar 64 192 utf8 utf8_general_ci varchar(64) select
def information_schema FILES LOGFILE_GROUP_NUMBER 9 YES bigint 19 0 bigint(4) select
def information_schema FILES ENGINE 10 NO varchar 64 192 utf8 utf8_general_ci varchar(64) select
def information_schema FILES FULLTEXT_KEYS 11 YES varchar 64 192 utf8 utf8_general_ci varchar(64) select
def information_schema FILES DELETED_ROWS 12 YES bigint 19 0 bigint(4) select
def information_schema FILES UPDATE_COUNT 13 YES bigint 19 0 bigint(4) select
def information_schema FILES FREE_EXTENTS 14 YES bigint 19 0 bigint(4) select
def information_schema FILES TOTAL_EXTENTS 15 YES bigint 19 0 bigint(4) select
def information_schema FILES EXTENT_SIZE 16 0 NO bigint 19 0 bigint(4) select
def information_schema FILES INITIAL_SIZE 17 YES bigint 20 0 bigint(21) unsigned select
def information_schema FILES MAXIMUM_SIZE 18 YES bigint 20 0 bigint(21) unsigned select
def information_schema FILES AUTOEXTEND_SIZE 19 YES bigint 20 0 bigint(21) unsigned select
def information_schema FILES CREATION_TIME 20 YES datetime 0 datetime select
def information_schema FILES LAST_UPDATE_TIME 21 YES datetime 0 datetime select
def information_schema FILES LAST_ACCESS_TIME 22 YES datetime 0 datetime select
def information_schema FILES RECOVER_TIME 23 YES bigint 19 0 bigint(4) select
def information_schema FILES TRANSACTION_COUNTER 24 YES bigint 19 0 bigint(4) select
def information_schema FILES VERSION 25 YES bigint 20 0 bigint(21) unsigned select
def information_schema FILES ROW_FORMAT 26 YES varchar 10 30 utf8 utf8_general_ci varchar(10) select
def information_schema FILES TABLE_ROWS 27 YES bigint 20 0 bigint(21) unsigned select
def information_schema FILES AVG_ROW_LENGTH 28 YES bigint 20 0 bigint(21) unsigned select
def information_schema FILES DATA_LENGTH 29 YES bigint 20 0 bigint(21) unsigned select
def information_schema FILES MAX_DATA_LENGTH 30 YES bigint 20 0 bigint(21) unsigned select
Voltar para Tabelas Voltar para Bases