• or use SELECT INTO:

    SELECT <YourCols>

    INTO #tbl

    FROM <YourTables>

    WHERE 1 = 0;

    ALTER TABLE #tbl ADD PRIMARY KEY (<YourCol(s)>);

    --etc

    This has the advantage that datatype changes will also be picked up.