sql script to create table with data code example

Example: sql create table with columns as another table

SELECT * INTO newtable FROM oldtable WHERE 1 = 0;