Skip to content
← SQL Prompt

How can we improve SQL Prompt?

SQL Prompt

Categories

JUMP TO ANOTHER FORUM

(thinking…)

Jump to object explorer

I just had a situation where I was in code, didn't have the object explorer opened up for the connection and wanted to look at the table properties, security etc.

It would be really good if you good offer up a "go to object in object explorer" feature - similar to the F12 shortcut to load an ALTER tab, but just changes the object explorer focus to the object that I am currently at.

29 votes

We're glad you're here

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

We’ll send you updates on this idea

Anonymous shared this idea  ·   ·  Report…  ·  Admin →

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
  • Justin Whaley commented  ·   ·  Report

    I've started using this in the 6.3 beta. This feature alone has almost doubled the usefulness of SQL Prompt to me. Keep up the good work Guys/Gals.

  • Klaus Ondrich commented  ·   ·  Report

    Hi Aaron, thank you for this awesome news. I forgot to mention: If the considered object is a synonym, then CTRL-F12 should directly jump to its base object - and context menu should offer both ways: Jumping to the synonym itself or to the base object.

  • AdminAaron Law (Admin, Redgate) commented  ·   ·  Report

    Hi Klaus,
    We're working on this now as Ctrl+F12 and on the context menu. We should have it out in a build sometime this month and I'll update this post once there's one for you to try.

  • Klaus Ondrich commented  ·   ·  Report

    I want to push this feature, since SQL Search now has "Go to object explorer". It would be great, if SQL Prompt offered such an option in context menu upon right-clicking an object in script window and object popup window (now available: Script/Summary & Copy).

  • AdminPaul Stephenson (Admin, Redgate) commented  ·   ·  Report

    Hi Ryan,

    It's not quite what you're asking, but if FOO is a stored procedure, function or view then F12 will script the object as an ALTER statement in a new query window. It's also "Script as ALTER" on the context menu. It's not implemented for tables though, partly because it's not clear what this should do. Should it open a CREATE TABLE script (which can't be executed) or an ALTER TABLE script (which won't tell you the current definition)?

  • AdminPaul Stephenson (Admin, Redgate) commented  ·   ·  Report

    I'm sorry Sandro -- this feature wasn't implemented due to other priorities, but we neglected to change the status here to reflect that. I'll do that now. This is something we're keen to add to SQL Search in due course, but we have no fixed dates at the moment.

  • Sandro Suter commented  ·   ·  Report

    The plan is great, but when? Planned over a year?

  • Justin Whaley commented  ·   ·  Report

    perhaps you could add a "go to object in object explorer" button to the hover detail popup.

  • Claudio commented  ·   ·  Report

    I'd like to have this on Sql Serach too. And the option to script that object (something like the F12).

  • AdminJustin Caldicott (Admin, Redgate) commented  ·   ·  Report

    Thanks for the suggestion.

    Are there any other navigation style enhancements from the Resharper world that would help you when working in SSMS?

    Justin
    Product Manager, SQL Productivity
    Red Gate

  • Josh commented  ·   ·  Report

    It needs to jump to the exact column, not just the table/object.

    Please enhance this function in SQL Search too. I recently searched for a column in a table with almost 100 columns and it was still very difficult to find my column in Object Explorer.

  • James commented  ·   ·  Report

    or, if the database is bound to source control or script files, it could open that file