In case you only need column names from a specific table:

1. Select the columns you want to get from your table.

   Select * from MY_TABLE limit 10;

2. Show the columns from the previous table

   show columns; SELECT "column_name" || ',' Columns FROM (select * from table(result_scan(last_query_id()))) WHERE "table_name" = 'MY_TABLE';

replace MY_TABLE with your table NAME

Modifying the Rajib Deb's answer.