View information about current database-wide settings.
Syntax
Use display database to display database information in the following ways:
Keyword | Description |
---|---|
all | Display information for all databases on the system. |
<dbs-name> | Display information about the specified database. |
on application | Display information about all databases on the specified application. |
request_history | Display information about recent requests for the database. Information about the last three requests is returned. |
Example
display database;
Displays information about all databases on the system.
display database Sample.Basic;
Displays information about the Sample.Basic database.