In SQL 2000 I could create one script that both dropped (if existed) and
created a view. Does SQL 2005 have anything like it anywhere. I can only
find separate DROP and CREATE scripting. Thanks.
They probably thought that scripting as ALTER would be sufficient. After
RTM they did add an "IF NOT EXISTS" option to Tools/Options/Scripting, so
they have been making improvements in the scripting area (and the things
that were left out), just not as fast as most of us would like.
SQL Server MVP
"David C" <dlch
@lifetimeinc.com> wrote in message