sql server create table as code example

Example 1: sql create table

CREATE TABLE table_name (

     column1 datatype,

     column2 datatype,

     column3 datatype,

  
....

);

Example 2: sql create table with columns as another table

SELECT * INTO newtable FROM oldtable WHERE 1 = 0;