have you seen this cat…?

have you seen this cat

Advertisements

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.