create table as in sql server code example
Example 1: SQL create a new table
CREATE TABLE table_name
(
column1 TYPE [COLUMN CONSTRAINTS],
column2 TYPE [COLUMN CONSTRAINTS],
column3 TYPE [COLUMN CONSTRAINTS],
[TABLE CONSTRAINTS...]
);
Example 2: sql create table with columns as another table
SELECT * INTO newtable FROM oldtable WHERE 1 = 0;