Wednesday, November 9, 2011

Create one table from another in SQL Server

To create one table from another in SQL Server you can use the following query:

select * into New_table from Existing_table

This will create a new table with the existing structure of old table.

No comments:

Post a Comment