Home     |     .Net Programming    |     cSharp Home    |     Sql Server Home    |     Javascript / Client Side Development     |     Ajax Programming

Ruby on Rails Development     |     Perl Programming     |     C Programming Language     |     C++ Programming     |     IT Jobs

Python Programming Language     |     Laptop Suggestions?    |     TCL Scripting     |     Fortran Programming     |     Scheme Programming Language

Cervo Technologies
The Right Source to Outsource

MS Dynamics CRM 3.0

Sql Server Programming

Drop and Create view 2005

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.

Aaron Bertrand
SQL Server MVP

"David C" <dlch@lifetimeinc.com> wrote in message


Add to del.icio.us | Digg this | Stumble it | Powered by Megasolutions Inc