Hi @Datanoob123 ,

You can use information_schema in system tables to get the details about columns and tables in Databricks. Here is a sample code that gives you the column names and number of tables with same column name.

SELECT column_name, COUNT(DISTINCT table_name) AS table_count
FROM information_schema.columns
GROUP BY column_name

 Hope this helps!