Outdated Version

You are viewing an older version of this section. View current production version.

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 MemSQL Commands).

Output

Column Description
Field Field name
Type Data type (see :ref:data_types)
Null Whether this column allows nulls
Key Key
Default Default value, if applicable
Extra Additional information

Example

memsql> 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)