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.