Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
Switch services using the Version drop-down list. Learn more about navigation.
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. |