.show tables command
Applies to: ✅ Microsoft Fabric ✅ Azure 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 |