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¶
DESCRIBE DATABASE [EXTENDED] db_name;
Keywords¶
EXTENDED: Displays the database properties.
Parameters¶
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¶
Create a database, for example, testdb, by referring to Example.
Run the following statement to query information about the testdb database:
DESCRIBE DATABASE testdb;