.show tables command

Applies to: ✅ Microsoft FabricAzure Data Explorer

Returns a set that contains the specified tables or all tables in the database.

Note

For table statistics, see the .show table data statistics command.

Permissions

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

Syntax

.show tables [(TableName [, ...])]

Learn more about syntax conventions.

Parameters

Name Type Required Description
TableName string The name of the table to show.

Returns

Output parameter Type Description
TableName string The name of the table.
DatabaseName string The database that the table belongs to.
Folder string The table's folder.
DocString string A string documenting the table.

Example

.show tables
.show tables (T1, ..., Tn)

Output example

Table Name Database Name Folder DocString
Table1 DB1 Logs Contains services logs
Table2 DB1 Reporting
Table3 DB1 Extended info
Table4 DB2 Metrics Contains services performance information