The following SQL select query will copy the source table structure to the destination table:


Alternatively right click on the table in SQL Server Management Studio or Visual Studio, Select Script Table as > Create to > New Query Editor Window, change the the name of the source table to the destination table and modify the scripts if necessary (eg. select part of the fields to copy) and then run the query.

I do not know how to copy the structure of the table i knew how to copy a table in another table.The Script is as follows:-

select * from Source_table as selection destination_table


ebook reader reviews