.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. |
Examples
Show all tables in the database
The following example shows information about all tables in the current database.
.show tables
Output
| Table Name | Database Name | Folder | DocString |
|---|---|---|---|
| StormEvents | Samples | Storm_Events | US storm events. Data source: https://www.ncdc.noaa.gov/stormevents| |
| demo_make_series1 | Samples | TimeSeries_and_ML | |
| demo_series2 | Samples | TimeSeries_and_ML | |
| demo_series3 | Samples | TimeSeries_and_ML | |
| demo_many_series1 | Samples | TimeSeries_and_ML | |
| ConferenceSessions | Samples | ADX_Conferences |
Show specific tables
The following example shows information about the specified tables.
.show tables (PopulationData, StormEvents, Trips, GeoRegions)
Output
| Table Name | Database Name | Folder | DocString |
|---|---|---|---|
| StormEvents | Samples | Storm_Events | US storm events. Data source: https://www.ncdc.noaa.gov/stormevents| |
| PopulationData | Samples | Storm_Events | |
| GeoRegions | Samples | NYC Taxi | |
| Trips | Samples | NYC Taxi |