mysql>
mysql> CREATE OR REPLACE VIEW COLUMNS
-> (TABLE_CREATOR, TABLE_NAME, COLUMN_NAME,
-> COLUMN_NO, DATA_TYPE, CHAR_LENGTH,
-> `PRECISION`, SCALE, NULLABLE, COMMENT) AS
-> SELECT UPPER(TABLE_SCHEMA), UPPER(TABLE_NAME),
-> UPPER(COLUMN_NAME), ORDINAL_POSITION,
-> UPPER(DATA_TYPE), CHARACTER_MAXIMUM_LENGTH,
-> NUMERIC_PRECISION, NUMERIC_SCALE, IS_NULLABLE,
-> COLUMN_COMMENT
-> FROM INFORMATION_SCHEMA.COLUMNS;
Query OK, 0 rows affected (0.01 sec)
mysql>