Database information_schema - table COLUMNS

Showing records 0 - 30 (159 total)
SQL-query : [Edit]
SELECT * FROM `COLUMNS` LIMIT 0, 30

   
rows starting from
   
   
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 CHARACTER_SET_NAME COLLATION_NAME COLUMN_TYPE COLUMN_KEY EXTRA PRIVILEGES COLUMN_COMMENT
Edit Delete   information_schema CHARACTER_SETS CHARACTER_SET_NAME 1   NO varchar 64 192     utf8 utf8_general_ci varchar(64)     select  
Edit Delete   information_schema CHARACTER_SETS DEFAULT_COLLATE_NAME 2   NO varchar 64 192     utf8 utf8_general_ci varchar(64)     select  
Edit Delete   information_schema CHARACTER_SETS DESCRIPTION 3   NO varchar 60 180     utf8 utf8_general_ci varchar(60)     select  
Edit Delete   information_schema CHARACTER_SETS MAXLEN 4 0 NO bigint     19 0     bigint(3)     select  
Edit Delete   information_schema COLLATIONS COLLATION_NAME 1   NO varchar 64 192     utf8 utf8_general_ci varchar(64)     select  
Edit Delete   information_schema COLLATIONS CHARACTER_SET_NAME 2   NO varchar 64 192     utf8 utf8_general_ci varchar(64)     select  
Edit Delete   information_schema COLLATIONS ID 3 0 NO bigint     19 0     bigint(11)     select  
Edit Delete   information_schema COLLATIONS IS_DEFAULT 4   NO varchar 3 9     utf8 utf8_general_ci varchar(3)     select  
Edit Delete   information_schema COLLATIONS IS_COMPILED 5   NO varchar 3 9     utf8 utf8_general_ci varchar(3)     select  
Edit Delete   information_schema COLLATIONS SORTLEN 6 0 NO bigint     19 0     bigint(3)     select  
Edit Delete   information_schema COLLATION_CHARACTER_SET_APPLICABILITY COLLATION_NAME 1   NO varchar 64 192     utf8 utf8_general_ci varchar(64)     select  
Edit Delete   information_schema COLLATION_CHARACTER_SET_APPLICABILITY CHARACTER_SET_NAME 2   NO varchar 64 192     utf8 utf8_general_ci varchar(64)     select  
Edit Delete   information_schema COLUMNS TABLE_CATALOG 1   YES varchar 512 1536     utf8 utf8_general_ci varchar(512)     select  
Edit Delete   information_schema COLUMNS TABLE_SCHEMA 2   NO varchar 64 192     utf8 utf8_general_ci varchar(64)     select  
Edit Delete   information_schema COLUMNS TABLE_NAME 3   NO varchar 64 192     utf8 utf8_general_ci varchar(64)     select  
Edit Delete   information_schema COLUMNS COLUMN_NAME 4   NO varchar 64 192     utf8 utf8_general_ci varchar(64)     select  
Edit Delete   information_schema COLUMNS ORDINAL_POSITION 5 0 NO bigint     19 0     bigint(21)     select  
Edit Delete   information_schema COLUMNS COLUMN_DEFAULT 6   YES varchar 64 192     utf8 utf8_general_ci varchar(64)     select  
Edit Delete   information_schema COLUMNS IS_NULLABLE 7   NO varchar 3 9     utf8 utf8_general_ci varchar(3)     select  
Edit Delete   information_schema COLUMNS DATA_TYPE 8   NO varchar 64 192     utf8 utf8_general_ci varchar(64)     select  
Edit Delete   information_schema COLUMNS CHARACTER_MAXIMUM_LENGTH 9   YES bigint     19 0     bigint(21)     select  
Edit Delete   information_schema COLUMNS CHARACTER_OCTET_LENGTH 10   YES bigint     19 0     bigint(21)     select  
Edit Delete   information_schema COLUMNS NUMERIC_PRECISION 11   YES bigint     19 0     bigint(21)     select  
Edit Delete   information_schema COLUMNS NUMERIC_SCALE 12   YES bigint     19 0     bigint(21)     select  
Edit Delete   information_schema COLUMNS CHARACTER_SET_NAME 13   YES varchar 64 192     utf8 utf8_general_ci varchar(64)     select  
Edit Delete   information_schema COLUMNS COLLATION_NAME 14   YES varchar 64 192     utf8 utf8_general_ci varchar(64)     select  
Edit Delete   information_schema COLUMNS COLUMN_TYPE 15   NO longtext 4294967295 4294967295     utf8 utf8_general_ci longtext     select  
Edit Delete   information_schema COLUMNS COLUMN_KEY 16   NO varchar 3 9     utf8 utf8_general_ci varchar(3)     select  
Edit Delete   information_schema COLUMNS EXTRA 17   NO varchar 20 60     utf8 utf8_general_ci varchar(20)     select  
Edit Delete   information_schema COLUMNS PRIVILEGES 18   NO varchar 80 240     utf8 utf8_general_ci varchar(80)     select  

   
rows starting from
   
   

Insert new row