.show databases command
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer
Returns a table in which every record corresponds to a database in the cluster that the user has access to.
Returns a table in which every record corresponds to a database in the eventhouse that the user has access to.
For a table that shows the properties of the context database, see .show database.
Syntax
.show databases
Learn more about syntax conventions.
Returns
| Column name | Column type | Description |
|---|---|---|
| DatabaseName | string |
The name of the database. |
| PersistentStorage | string |
The persistent storage "root" of the database. For internal use only. |
| Version | string |
The version of the database. For internal use only. |
| IsCurrent | bool |
Whether this database is the database context of the request. |
| DatabaseAccessMode | string |
One of ReadWrite, ReadOnly, ReadOnlyFollowing, or ReadWriteEphemeral. |
| PrettyName | string |
The pretty name of the database, if any. |
| ReservedSlot1 | bool |
Reserved. For internal use only |
| DatabaseId | guid |
A globally unique identifier for the database. For internal use only. |