SQL Server Script Wizard

Question

I am using SQL Server 2005. If I try to generate scripts for the dB using the Generate Scripts wizard in the management studio (Right click dB-> Tasks-> Generate Scripts)

I get no option like IF EXISTS DROP condition in the list. Whereas some of the SQL Servers installed on different machines have this option enabled.

Is the service pack missing or any option needs to be modified to get this feature?

Mitch Wheat · Accepted Answer · 2009-01-28 10:57:22Z

1

If you right-click there is a page in the wizard where you can set your scripting options. One option is "Include IF NOT EXISTS". Or goto the Tools -> Options -> SQL Server Object Explorer-> Scripting to set this.

answered Jan 28, 2009 at 10:57

Mitch Wheat

302k44 gold badges482 silver badges552 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user46795 Over a year ago

"Include IF NOT EXISTS"=true will include the table/procedure if it doesnt exist. But what I need is, If it exists drop it. And then create whatever in the script.

Sam · Accepted Answer · 2009-01-28 21:16:42Z

0

When I execute this command, all I get is a CREATE DATABASE statement and then the associated options are set.

You want to generate a DROP DATABASE statement?

It doesn't look like this functionality is present, but you can generate the drop statement and then paste it in front.

answered Jan 28, 2009 at 21:16

Sam

7,6987 gold badges55 silver badges62 bronze badges

Collectives™ on Stack Overflow

SQL Server Script Wizard

2 Answers 2

1 Comment

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Related