Find all table with multiple columns name criteria

Question

Through query page, I can search all tables where column == "something". Seems we're not able to make AND/OR from UI. So, I would like to know if there is a KQL query that can let search accross tables about column names with multiple criteria. Example : Finding all table where it contains one column named "Customer_ID" and one column named "mail" Thanks :)

Could you share what you have tried?

Balaji
– Balaji

2025-01-29 12:24:28 +00:00
Commented Jan 29 at 12:24 — Balaji
– Balaji, Commented Jan 29 at 12:24

fdomn-m · Accepted Answer · 2025-01-29 12:37:54Z

0

I found the solution:

show database *db_name* schema 
| where ColumnName contains "xxx" or ColumnName contains "yyy" 
| summarize make_list(ColumnName) by TableName 
| where list_ColumnName contains "xxx" and list_ColumnName contains "yyy"

edited Jan 29 at 12:37

fdomn-m

28.8k8 gold badges39 silver badges70 bronze badges

answered Jan 29 at 12:31

Pierrot

191 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Find all table with multiple columns name criteria

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related