Can I find remaining 85-90 columns which was not provided to me? in databricks

Asked Jan 18 '23 at 11:02

Active Jan 18 '23 at 11:23

Viewed 25 times

I have a table in Databricks which has almost 100's columns. I was given with some 10-15 columns, can I find remaining 85-90 columns which was not provided to me?

For example, Table 'A has column name like (a,b,c,d,e,f,g,h,....z), I was given with (a,f,h)

I have to find (b,c,d,e,g,i.....z)

edited Jan 18 '23 at 11:23

asked Jan 18 '23 at 11:02

Salman

Query `sys.tables` and `sys.columns`..? – Thom A Jan 18 '23 at 11:05
Use `INFORMATION_SCHEMA.COLUMNS` – Ullas Jan 18 '23 at 11:06
can you give full query – Salman Jan 18 '23 at 11:07

Can I find remaining 85-90 columns which was not provided to me? in databricks

0 Answers0