DESCRIBE/SHOW-Lindorm(Lindorm)-阿里云帮助中心

You can use the DESCRIBE syntax to view details of a specified table. You can use the SHOW syntax to view all schemas of your databases.

Examples

Execute the following statement to view all schemas of your databases.
```
SHOW databases;
```
Execute the following statement to view all table of a specified schema. By default, tables for the default schema are displayed.
```
SHOW tables;
```
Execute the following statement to view details of the specified table named test, including information about the columns and data types of columns:
```
DESCRIBE test;
```