Add a new "Modify" menu item when right clicking views in Object Explorer
To get an ALTER script for an existing stored proc or UDF you just need to right click it in Object Explorer and select Modify. For views you can't do this. You have to select "Script view as.." then "Alter to..." then "New query editor window". It's only two extra mouse clicks but they are two very annoying mouse clicks! I was hoping this would have come back for SQL2012 as you used to be able to do this in SQL2000, but it hasn't. Redgate to the rescue?
Thomas Franz commented
are 3.5 years enough wait time for a new context menu entry? Hoping to see it soon :-)
I long for this feature to come back ever since it was taken away in SQL 2008. Why can you Modify a stored proc with one click or anything else with one click EXCEPT a View. MS Response: As designed. Whatever!
I totally second this issue. SQL 2005 had it and then for some reason MS decided to get rid of it in SQL 2008 and forward. I have been searchig for something like this ever since. I think Red-Gate should come to our rescue. :)
AdminJustin Caldicott (Admin, Redgate) commented
Thanks for the suggestion Derek. We'll be thinking about something along those lines in a future version.