Home Kusto: How Do I Find all Databases which have a Table by its name within a Kusto Server

Questions

Kusto: How Do I Find all Databases which have a Table by its name within a Kusto Server

December 14, 2022

I have a Kusto server. The server has multiple Databases.
I have a Table name, let’s say Table1. But I don’t know which database or databases have that table.
Is there a Kusto query to achieve this?

>Solution :

.show databases schema

.show databases schema 
| where isempty(ColumnName)
| where TableName == "Customers"

DatabaseName	TableName	ColumnName	ColumnType	IsDefaultTable	IsDefaultColumn	PrettyName	Version	Folder	DocString
ContosoSales	Customers			false	false

Fiddle

Following the OP question:

.show databases schema 
| take 5

The 1st row describes the database
The 2nd row describes the table
The other rows describe the columns

DatabaseName	TableName	ColumnName	ColumnType	IsDefaultTable	IsDefaultColumn	Version	Folder	DocString
Samples				false	false	v3333.3
Samples	StormEvents			false	false		Storm_Events	US storm events. Data source: https://www.ncdc.noaa.gov/stormevents
Samples	StormEvents	StartTime	System.DateTime	false	false
Samples	StormEvents	EndTime	System.DateTime	false	false
Samples	StormEvents	EpisodeId	System.Int32	false	false