Friday, March 6, 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.