Generate create script of a existing database , without data - SQL Server 2008

Question

Is there a feature in sql server 2008 management studio to generate database create scripts from existing database without data and with all the relationships maintained.

score 1 · Answer 1 · edited Mar 18 '15 at 09:22

1

Go into: Tasks > Generate Scripts Then,

in Choose Script Options set Scrpit Data = False (default)

edited Mar 18 '15 at 09:22

Piotr Dajlido

1,982
15
28

answered Mar 18 '15 at 08:37

vinhvoz007

11
1

score 1 · Answer 2 · answered Nov 26 '10 at 10:15

1

Yes, of course.

answered Nov 26 '10 at 10:15

ceth

44,198
62
180
289

score -3 · Answer 3 · answered Nov 26 '10 at 10:19

-3

In SSMS, right click the db and select "Script database as Create to"... whatever you want

answered Nov 26 '10 at 10:19

iDevlop

24,841
11
90
149

This is wrong, doing it this way only sets up the actual DB not the tables etc.. within. – leinad13 Jan 24 '17 at 10:35

Generate create script of a existing database , without data - SQL Server 2008

3 Answers3