Where did "Modify" (aka "Edit") for views go? Gone in SQL Server 2008 Management Studio?!
Right-clicking a view in SQL Management Server Object Explorer no longer offer a "Modify" (aka "Edit") menu item, only "Design". To alter a view one have to select "Script view as", "Alter to", "New Query Edit Window". Its rather tiresome. Is there any way I can bring back the standard "Modify" and go from painstakingly slow three mouse-clicks to one? Or is there any other shortcut? Any ideas welcome!
Yeah, it's missing and the only current way is tu use Script View As -> Alter To -> New Edito Window. It is possible to add it back by writing a small custom plugin which will script the view to new query window. :-)