Databases management
Applies to: ✅ Azure Data Explorer
This topic describes the following database management commands:
| Command | Description |
|---|---|
.show databases |
Returns a table in which every record corresponds to a database in the cluster that the user has access to |
.show database |
Returns a table showing the properties of the context database |
.show cluster databases |
Returns a table showing all databases attached to the cluster and to which the user invoking the command has access |
.alter database prettyname |
Alters a database's pretty (friendly) name |
.show database schema |
Returns a flat list of the structure of the selected databases with all their tables and columns in a single table or JSON object |
.show databases entities |
Returns a list of databases' entities (for example: tables, materialized views, etc.) |
.execute database script |
Executes batch of management commands in scope of a single database |