column name information in databricks

Question

Hey,

how to find particular column name information in datarbricks

example

SELECT s.name, t.name, c.name

FROM sys.columns c

JOIN sys.tables t ON c.object_id = t.object_id

JOIN sys.schemas s ON t.schema_id = s.schema_id

WHERE c.name LIKE '%mob%'

how we can convert this query in databricks

Answer 1

Thanks for posting your question in the Microsoft Q&A forum.

In Databricks, you can achieve similar functionality using the INFORMATION_SCHEMA.COLUMNS view, which provides metadata about columns in tables.

SELECT table_schema AS schema_name, table_name, column_name FROM INFORMATION_SCHEMA.COLUMNS WHERE column_name LIKE '%mob%'

** Please don't forget to close up the thread here by upvoting and accept it as an answer if it is helpful **