> For the complete documentation index, see [llms.txt](https://learnsql.gitbook.io/lernmysql/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://learnsql.gitbook.io/lernmysql/describe-ngoai-de-soi-cau-truc-cua-database-no-con-dung-de-soi-cau-truc-cua-table.md).

# Describe ngoài để soi cấu trúc của database nó còn dùng để soi cấu trúc của table;

```
MariaDB [learnsql]> show tables;
+--------------------+
| Tables_in_learnsql |
+--------------------+
| Employees          |
| Orders             |
| user               |
+--------------------+

MariaDB [learnsql]> describe Employees;
+--------------+--------------+------+-----+---------+-------+
| Field        | Type         | Null | Key | Default | Extra |
+--------------+--------------+------+-----+---------+-------+
| Employees_ID | int(10)      | YES  |     | NULL    |       |
| Name         | varchar(111) | YES  |     | NULL    |       |
+--------------+--------------+------+-----+---------+-------+
```