Help Center/ Data Lake Insight/ SQL Syntax Reference (Kuala Lumpur Region)/ Spark SQL Syntax Reference/ Databases/ Viewing a Specified Database
Updated on 2023-03-06 GMT+08:00
View PDF
Share

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.

Parameters

Table 1 Parameter description

Parameter

Description

db_name

Database name, which consists of letters, digits, and underscores (_). The value cannot contain only digits or start with a digit or underscore (_).

Precautions

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

Example

  1. Create a database, for example, testdb, by referring to Example.
  2. Run the following statement to query information about the testdb database: 
    1
    		 
    DESCRIBE DATABASE testdb;
Parent topic: Databases