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.

David

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
http://www.sqlblog.com/
http://www.aspfaq.com/5006

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

news:%23CKuNnuoHHA.4512@TK2MSFTNGP03.phx.gbl...

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