Copy Schema
I want to copy a large DB schema to make changes for testing, but do not want any data.
August 23rd, 2015 12:10pm
script the database as create to by right clicking the database
https://msdn.microsoft.com/en-us/library/ms178078.aspx
https://msdn.microsoft.com/en-us/library/ms188664.aspx ==>Copy database
Free Windows Admin Tool Kit Click here and download it now
August 23rd, 2015 1:16pm
Hi Citrus,
you should generate script as follows:
- Right click on Database, go to Tasks-> Generate Scripts
- Select your table and click next
- On next screen, click on "Advanced" button, here you find all configuration to generate scripts with Data, Fks, constraints etc..
OR
SELECT *INTO NewEmptyTable
FROM YourTable
WHERE 0 = 1 ;
August 23rd, 2015 1:29pm