Mega Code Archive

 

Categories / MySQL / Command Mysql

 

Create view for columns

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>