SQL Server 2005 Scripting Options 1

[jbenson001]

Hi everyone,

I am trying to find how to set the scripting opitons in 2005. For example, in 2000 you have a wizard where you can choose multiple objects and select multiple scripting options such as generation a CREATE and/or DROP statement:

if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Makes]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[Makes]
GO
 --Create table here .. etc

In 2005 you can right click a table, or SP for example and choose to generate the script to the clipboard, file,or new ediort window. What I would like to know if is there a way to generate the scripts like in 2000? Is there a way to get it to generate the DROP and CREATE statements and choose various options?

Thanks...
Jim

 

[SQLDenis]

right click on the DB-->tasks-->generate scripts
this will start the scripting wizard

However you can script drop OR create statements

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[SQLDenis]

also check out Scriptio by Bill Graziano

http://weblogs.sqlteam.com/billg/archive/2006/06/13/10208.aspx

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[jbenson001]

Thanks Denis, just what I was looking for. I wonder why they changed the scipting options... It was helpful to have the DROP before the create...
Microsoft is always strange.

Thanks again

Jim

 

[jbenson001]

Denis... ScripIO is awesome.. Gives the options that 2000 had..

Thanks again...

 

[jbenson001]

Denis... ScripIO is awesome!!!!.. Gives the options that 2000 had..

Thanks again...