title: What is the equivalent of 'CREATE TABLE ... LIKE ..." in SQL Server
body: <p>I am working with SQL Server (I am a SQL Server noob) and trying to alter a table. I want to <code>CREATE TABLE LIKE</code> to safely store data while I drop keys and constraints and all the other rigamorole that SQL Server seems to require when altering on the original table but I have not been able to find a match to that command...</p>