This topic describes the syntax that is used to query the attributes of a database.
Syntax
describe_database_statement ::= DESCRIBE DATABASE database_name;
The DESCRIBE DATABASE statement returns a result set as a table. The following table describes the schema of a table that is returned.
Column name | Type |
---|---|
attribute | VARCHAR |
value | VARCHAR |
Example
The following sample code provides an example on how to query the attributes of a database named DB1:
DESCRIBE DATABASE DB1;
+-----------+-------+
| attribute | value |
+-----------+-------+
| ttl | 60 |
+-----------+-------+