How to get all the tables name with a specific column or columns in a database?

ramankr48
Databricks Partner

‎10-18-2022 04:08 AM

let's say there is a database db in which 700 tables are there, and we need to find all the tables name in which column "project_id" is present.

just an example for ubderstanding the questions.