You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

DESCRIBE

Describe the specified table.

Syntax

DESCRIBE [db_name.]table_name

Remarks

  • table_name is the name of a table in a MemSQL database.
  • db_name is the name of a MemSQL database. Not needed if the table exists in the current MemSQL database.
  • This command can be run on any MemSQL node (see Node Requirements for MemSQL Commands ).

Examples

memsql> DESCRIBE test;

+-------+-------------+------+-----+---------+----------------+
| Field | Type        | Null | Key | Default | Extra          |
+-------+-------------+------+-----+---------+----------------+
| id    | int(11)     | NO   | PRI | NULL    | auto_increment |
| v     | varchar(10) | NO   |     | NULL    |                |
+-------+-------------+------+-----+---------+----------------+

2 rows in set (0.00 sec)


mysql> describe memsql_demo.customer;
+------------+---------------+------+-----+---------+-------+
| Field      | Type          | Null | Key | Default | Extra |
+------------+---------------+------+-----+---------+-------+
| custkey    | int(11)       | NO   | PRI | NULL    |       |
| name       | varchar(25)   | NO   |     | NULL    |       |
| address    | varchar(40)   | NO   |     | NULL    |       |
| nationkey  | int(11)       | NO   | MUL | NULL    |       |
| phone      | char(15)      | NO   |     | NULL    |       |
| acctbal    | decimal(15,2) | NO   |     | NULL    |       |
| mktsegment | char(10)      | NO   |     | NULL    |       |
| comment    | varchar(117)  | NO   |     | NULL    |       |
| zip2       | binary(5)     | YES  |     | NULL    |       |
| balance    | double        | YES  |     | NULL    |       |
+------------+---------------+------+-----+---------+-------+
10 rows in set (0.00 sec)