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)