CODEWITHSUNDEEP
sqldatabricks
Tim
Tim

Reputation: 583

Databricks show all columns in table

I have a table with a lot of columns... the result is getting truncated and I cannot scroll to the right.

How can I show all columns using SQL?

I have tried:

%sql SHOW COLUMNS IN 

%sql  DESCRIBE EXTENDED

amongst others.

Upvotes: 0

Views: 5034

Answers (1)

Isolated
Isolated

Reputation: 6454

If you need the column and type, then use DESCRIBE as you mentioned. I think you're just missing "table" after describe.

%sql
describe table database_name.table_name

Upvotes: 1

Related Questions