MySQL Tutorial/Table/Describe Table Structure

Check the created table by issuing a "describe" command

   <source lang="sql">

DESCRIBE tableName;</source>

To verify the table structure, use a DESCRIBE statement

   <source lang="sql">

mysql> mysql> mysql> CREATE TABLE myTable (

   -> id           int,
   -> first_name   VARCHAR(20),
   -> last_name    VARCHAR(20),
   -> sex          CHAR(1),
   -> start_date   DATE,
   -> end_date     DATE);

Query OK, 0 rows affected (0.05 sec) mysql> mysql> show tables; +----------------+ | Tables_in_test | +----------------+ | mytable | +----------------+ 1 row in set (0.00 sec) mysql> mysql> describe myTable; +------------+-------------+------+-----+---------+-------+ | Field | Type | Null | Key | Default | Extra | +------------+-------------+------+-----+---------+-------+ | id | int(11) | YES | | NULL | | | first_name | varchar(20) | YES | | NULL | | | last_name | varchar(20) | YES | | NULL | | | sex | char(1) | YES | | NULL | | | start_date | date | YES | | NULL | | | end_date | date | YES | | NULL | | +------------+-------------+------+-----+---------+-------+ 6 rows in set (0.00 sec) mysql> mysql> drop table myTable; Query OK, 0 rows affected (0.00 sec) mysql></source>