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 :)
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 :)
Share Improve this question asked Jan 29 at 9:23 PierrotPierrot 191 silver badge4 bronze badges 1- Could you share what you have tried? – Balaji Commented Jan 29 at 12:24
1 Answer
Reset to default 0I 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"