SHOW COLUMNS
Show the list of columns within a given table.
Syntax
SHOW [FULL] COLUMNS {FROM | IN} tbl_name [{FROM | IN} db_name] [LIKE 'pattern' | WHERE expr]
Remarks
LIKE
“pattern” can be used to filter the list by name. SQL LIKE clause.WHERE expr
can be used to filter the results by other predicates. SQL WHERE clause.This command must be run on the master aggregator or a child aggregator node (see Node Requirements for SingleStore DB Commands).
Output
Column | Description |
---|---|
| Field name |
| Data type (see :ref: |
| Whether this column allows nulls |
| Key |
| Default value, if applicable |
| Additional information |
Example
SHOW COLUMNS IN mytbl; +----------+------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +----------+------------+------+-----+---------+-------+ | seq | int(11) | YES | MUL | NULL | | | state | int(11) | YES | | NULL | | | st_case | varchar(8) | YES | | NULL | | | veh_no | varchar(2) | YES | | NULL | | | drimpair | varchar(2) | YES | | NULL | | +----------+------------+------+-----+---------+-------+ 5 rows in set (0.00 sec)