SHOW COLUMNS - Regatta

This view has a row for every column in every table in the database. The output is ordered by the (table_name, column_name) columns. Data can be filtered with IN TABLE table_name syntax. The following table lists the output’s columns:

Column name	Data type	Description
TABLE_NAME	`VARCHAR(127)`	The table name
COLUMN_NAME	`VARCHAR(127)`	The column name. This is the filter column
DATA_TYPE	`VARCHAR(30)`	The column data type. One of the supported data types (Data Types)
COLUMN_SIZE	`INT`	The number of chars for CHAR, the maximum number of chars for VARCHAR, the precision of the column for NUMERIC, REAL or DOUBLE PRECISION, the number of fractional digits retained in the seconds field for TIME or TIMESTAMP. Null for all other types.
SCALE	`INT`	The number of digits to the right of the decimal point in a number. Null when not relevant
NOT_NULL	`BOOLEAN`	True if defined as NOT NULL.
DEFAULT	`VARCHAR(8000)`	The column’s default value (NULL if there is no default value).
ORDINAL_POSITION	`INT`	Ordinal position of the column within the table (count starts at 1)

⌘I