DESCRIBE
Describe the specified table.
Syntax
DESCRIBE [<database_name>]<table_name>;
Remarks
<table_name>
is the name of a table in a SingleStore DB database.<database_name>
is the name of a SingleStore DB database. Not needed if the table exists in the current SingleStore DB database.This command can be run on any SingleStore DB node (see Node Requirements for SingleStore DB Commands ).
Examples
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) 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)