Add "alter object" next to "select object in object explorer"
For example on a stored procedure, it's time consuming to first click select object in explorer, then right click on the object, then click modify. For a table, same, but clicking design. Plus sometimes if the database sproc isn't expanded yet its slow as the left side menu bounces around expanding first...
Ludvig Derning commented
Excellent: But use "drop and create to" instaed so not to destroy the debugging with wrong editions in cache.
Mark Plumpton commented
definitely needed. Note there are at least 4 different suggestions now that cover this idea and the related context menu idea. Can the moderator please combine these so the vote count is reflected. thanks
Please add this to the Right Click context menu for Search Results too. So I can search for something, right click it, select "Script as Alter" and get a new query window the the alter script.