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.

Tables of Database `information_schema` edit
create table:
copy table:
select table:     

 

Table `COLUMNS`
Table properties of `COLUMNS` (19 Fields)Name
Engine
Row Format
Charset
Collation
Comment
 

 

Fields of table `COLUMNS`
insert new field

 FieldTypeSizeNULLKeyAttributeDefaultExtraCollationComment
edit field  delete field  1.TABLE_CATALOGvarchar512noutf8_general_ci
edit field  delete field  2.TABLE_SCHEMAvarchar64noutf8_general_ci
edit field  delete field  3.TABLE_NAMEvarchar64noutf8_general_ci
edit field  delete field  4.COLUMN_NAMEvarchar64noutf8_general_ci
edit field  delete field  5.ORDINAL_POSITIONbigint21nounsigned0
edit field  delete field  6.COLUMN_DEFAULTlongtextyesutf8_general_ci
edit field  delete field  7.IS_NULLABLEvarchar3noutf8_general_ci
edit field  delete field  8.DATA_TYPEvarchar64noutf8_general_ci
edit field  delete field  9.CHARACTER_MAXIMUM_LENGTHbigint21yesunsigned
edit field  delete field  10.CHARACTER_OCTET_LENGTHbigint21yesunsigned
edit field  delete field  11.NUMERIC_PRECISIONbigint21yesunsigned
edit field  delete field  12.NUMERIC_SCALEbigint21yesunsigned
edit field  delete field  13.CHARACTER_SET_NAMEvarchar32yesutf8_general_ci
edit field  delete field  14.COLLATION_NAMEvarchar32yesutf8_general_ci
edit field  delete field  15.COLUMN_TYPElongtextnoutf8_general_ci
edit field  delete field  16.COLUMN_KEYvarchar3noutf8_general_ci
edit field  delete field  17.EXTRAvarchar27noutf8_general_ci
edit field  delete field  18.PRIVILEGESvarchar80noutf8_general_ci
edit field  delete field  19.COLUMN_COMMENTvarchar1024noutf8_general_ci

Indexes of table `COLUMNS`
  Name Columns Size Type Duplicates allowed Cardinality Comment
No Indexes in Table