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

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)

Was this Article Helpful?

Thanks For Your Feedback!