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.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s