Help Center> Data Lake Insight> SQL Syntax Reference> SQL Syntax of Batch Jobs> Databases> Viewing a Specified Database
View PDF

Viewing a Specified Database

Function

This syntax is used to view the information about a specified database, including the database name and database description.

Syntax

1
 
DESCRIBE DATABASE [EXTENDED] db_name;

Keyword

EXTENDED: Displays the database properties.

Precautions

If the database to be viewed does not exist, the system reports an error.

Example

To query the information about the testdb database, run the following statement:

1
 
DESCRIBE DATABASE testdb;
Parent topic: Databases