how to create table as columns like from other tables code example Example: sql create table with columns as another table SELECT * INTO newtable FROM oldtable WHERE 1 = 0;