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:

  1. Right click on Database, go to Tasks-> Generate Scripts
  2. Select your table and click next
  3. 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

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics