SELECT TABLE_NAME,COLUMN_NAME,data_type,character_maximum  _length from information_schema.columns