create table tablename as 1st query code example

Example: sql create table with columns as another table

SELECT * INTO newtable FROM oldtable WHERE 1 = 0;