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