Databases management
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 |
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for