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.

CodePudding user response：

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