Databases management

This article describes Databases management.

This topic describes the following database management commands:

CommandDescription
.show databasesReturns a table in which every record corresponds to a database in the cluster that the user has access to.
.show databaseReturns a table showing the properties of the context database.
.alter database prettyname commandAlters a database’s pretty (friendly) name.
.drop database prettyname commandDrops a database’s pretty (friendly) name.
.show database schemaReturns 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 violationsReturns a list of the schema validation issues within a database.
.show databases entitiesReturns a list of databases’ entities (for example: tables, materialized views, etc.)
.execute database scriptExecutes batch of management commands in scope of a single database.
CommandDescription
——–————
.show databasesReturns a table in which every record corresponds to a database in the eventhouse that the user has access to.
.show databaseReturns a table showing the properties of the context database.
.show database schemaReturns 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 violationsReturns a list of the schema validation issues within a database.
.show databases entitiesReturns a list of databases’ entities (for example: tables, materialized views, etc.)
.execute database scriptExecutes batch of management commands in scope of a single database.

|.execute database script | Executes batch of management commands in scope of a single database. |