Script Table as Select To

1

Is there a way to get a Create Statement for a Table that instead of
Select * from table gets you all the columns explicitly stated.

Select column1, column2, … column100 from table

The SHOW CREATE TABLE table_name does not appear to work

2

@matthias.mazur The show create table is a Hive command. Dremio does not have that SQL. You should be able write a SQL by selecting from information_schema.columns