Edit

.show databases entities command

  • Article

The following command shows databases' entities, such as tables, materialized views, external tables, etc.

Permissions

You must have at least Database User, Database Viewer, or Database Monitor permissions to run these commands. For more information, see role-based access control.

.show databases entities

Syntax

.show databases entities [with (Options)]

Supported options

Key Value Description
showObfuscatedStrings bool Defaults to false. If true, obfuscated strings in database entity bodies are shown. To use this option, you must either be a database admin or entity creator. If you don't have these permissions, the obfuscated strings are not shown.
resolveFunctionsSchema bool Defaults to false. If true, returned stored functions have output schema resolved.

Returns

Returns a list of entities of all cluster databases visible to the user. Database entities are: tables, materialized views, external tables, etc.

Important

By default, all databases' entites are returned. To make the command execution more optimal, add a where condition that filters by specific databases and/or entity types or names (see examples section in this article).

Returned columns

Column Description
DatabaseName Name of the database where the entity is defined
EntityType One of: Table, MaterialiedView, ExternalTable, Function, EntityGroup
EntityName The name of the entity
DocString Entity documentation, if exists
Folder Folder name under which the entity is located
CslInputSchema Entity input schema in CSL schema format, if applicable. For functions, the schema is for the function parameters
Content Entity content, if applicable. For functions, it's a body of the function
CslOutputSchema Entity output schema in CSL schema format
Properties Dynamic structure that provides more details on the entity (currently unused)

Examples

Show databases entities

.show databases entities with (showObfuscatedStrings=true)
| where DatabaseName == "TestDB"

Output

DatabaseName EntityType EntityName DocString Folder CslInputSchema Content CslOutputSchema Properties
TestDB Table GeoIP Table containing Geolocation info per IP network My tables ['network']:string, locale_code:string, continent_code:string, continent_name:string, country_iso_code:string,country_name:string {}
TestDB MaterializedView MV1 My first materialized view a:long, b:string, c:long {}
TestDB Function MeaningLessFn My first function Functions (T:(s:string,a:long,b:long), k:long) {T | extend substring(s, a, b) | take k} {}

Resolving functions schema

.show databases entities with (resolveFunctionsSchema=true)
| where DatabaseName == "TestDB" and EntityType == "Function" and EntityName == "MeaningLessFn"

Output

DatabaseName EntityType EntityName DocString Folder CslInputSchema Content CslOutputSchema Properties
TestDB Function MeaningLessFn My first function Functions (T:(s:string,a:long,b:long), k:long) {T | extend substring(s, a, b) | take k} s:string, a:long, b:long, Column1:string {}