Home Forums SQL Server 2012 SQL 2012 - General SQL Server 2012 Server Collation vs. Database Collation RE: SQL Server 2012 Server Collation vs. Database Collation
Ken McKelvey
SSCoach
Points: 18768
More actions
May 5, 2016 at 7:37 am
#1876845
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.