sql查询表结构

以mysql为例有两个命令可义显示表结构：

• desc(describe缩写) TABLE;

mysql> desc person;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| LastName  | varchar(20) | YES  |     | NULL    |       |
| FirstName | varchar(5)  | YES  |     | NULL    |       |
| Address   | varchar(30) | YES  |     | NULL    |       |
| City      | varchar(10) | YES  |     | NULL    |       |
+-----------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

• explain TABLE;

mysql> explain person;
+-----------+-------------+------+-----+---------+-------+
| Field     | Type        | Null | Key | Default | Extra |
+-----------+-------------+------+-----+---------+-------+
| LastName  | varchar(20) | YES  |     | NULL    |       |
| FirstName | varchar(5)  | YES  |     | NULL    |       |
| Address   | varchar(30) | YES  |     | NULL    |       |
| City      | varchar(10) | YES  |     | NULL    |       |
+-----------+-------------+------+-----+---------+-------+
4 rows in set (0.00 sec)