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. |
| .alter database prettyname command | Alters a database's pretty (friendly) name. |
| .drop database prettyname command | Drops 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 database schema violations | Returns a list of the schema validation issues within a database. |
.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. |