Skip to content
← SQL Search

How can we improve SQL Search?

'Alter object directly from SQL Search results' has been merged into this idea

SQL Search: Graphical User Interface

Categories

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...

216 votes
Vote

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
You have left! (?) (thinking…)
Chris Suire shared this idea  ·   ·  Report…  ·  Admin →
How important is this to you?

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close

We're glad you're here

Please sign in to leave feedback
Signed in as (Sign out)
Close
Close
Submitting...
An error occurred while saving the comment
  • Claudio commented  ·   ·  Report

    The same behaviour as F12 shortcut from Sql Prompt would be great

  • Jose Montoya commented  ·   ·  Report

    and the default action of double clic should be "alter object"

  • Ludvig Derning commented  ·   ·  Report

    Excellent: But use "drop and create to" instaed so not to destroy the debugging with wrong editions in cache.

  • Mark Plumpton commented  ·   ·  Report

    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

  • Mark Plumpton commented  ·   ·  Report

    I think the suggestion to "Add option to the context menu for a result to open the item for modification" would be better.

  • Mark Plumpton commented  ·   ·  Report

    Under the search results and above the script of he selected result is a link "Select object in Object Explorer" - you could add another link for "ALTER script in query editor" and/or "DROP/CREATE script in query editor".

  • GBarker commented  ·   ·  Report

    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.