Sql Server Programming :: Drop and Create view 2005


	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... - Hide quoted text - > 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 http://www.sqlteam.com/publish/scriptio/