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 SingleStoreDB Commands).
See the Permission Matrix for the required permission.
Output
Column | Description |
---|---|
| Field name |
| |
| Whether this column allows nulls |
| An attribute or attributes that uniquely identify table rows. There are several types of keys with the most common being primary, unique, and foreign. |
| 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)