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.
>Solution :
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