SQL - DESC Statement

DESCRIBE Statement is used to show the structure of a table:

DESC table name;

example:
MariaDB [testdatabase]> desc employee;
+-------------+--------------+------+-----+---------+-------+
| Field       | Type         | Null | Key | Default | Extra |
+-------------+--------------+------+-----+---------+-------+
| empno       | int(6)       | NO   | PRI | NULL    |       |
| name        | varchar(30)  | NO   |     | NULL    |       |
| designation | varchar(20)  | YES  |     | NULL    |       |
| department  | varchar(20)  | YES  |     | NULL    |       |
| basicpay    | decimal(8,2) | YES  |     | NULL    |       |
| da          | decimal(8,2) | YES  |     | NULL    |       |
| total       | decimal(8,2) | YES  |     | NULL    |       |
+-------------+--------------+------+-----+---------+-------+
7 rows in set (0.36 sec)

MariaDB [testdatabase]>