SHOW COLUMNS

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.
This command must be run on the Master Aggregator or a child aggregator node (see Node Requirements for SingleStore Commands).
See the Permission Matrix for the required permission.

Output

Column	Description
`Field`	Field name
`Type`	Data types
`Null`	Whether this column allows nulls
`Key`	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`	Default value, if applicable
`Extra`	Additional information

Example

SQL

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)

On this page

Syntax

Remarks

Example

Was this article helpful?

On this page

Was this article helpful?