Month: March 2009

Copy existing SQL Table structure into a new empty table..? Easy…

Here’s the SQL Server thing: I want to copy an existing table’s structure, but not the data.

Here’s thefix:
SELECT * INTO MyNewTable
FROM ExistingTable
where 0=1

… which will do exactly that! Nice. Thanks to Josh for that.