How can we improve SQL Prompt?

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.

55 votes
Vote
Sign in
Check!
(thinking…)
Reset
or sign in with
  • facebook
  • google
    Password icon
    I agree to the terms of service
    Signed in as (Sign out)
    You have left! (?) (thinking…)
    Anonymous shared this idea  ·   ·  Flag idea as inappropriate…  ·  Admin →
    RyanRyan shared a merged idea: Allow a hotkey (F12?) to jump right to table/SP/etc from code.  ·   · 
    Kris DagesKris Dages shared a merged idea: "Navigate to" options for symbols  ·   · 

    13 comments

    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      I agree to the terms of service
      Signed in as (Sign out)
      Submitting...
      • Justin WhaleyJustin Whaley commented  ·   ·  Flag as inappropriate

        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 OndrichKlaus Ondrich commented  ·   ·  Flag as inappropriate

        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.

      • Klaus OndrichKlaus Ondrich commented  ·   ·  Flag as inappropriate

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

      • Paul StephensonAdminPaul Stephenson (Admin, Red Gate) commented  ·   ·  Flag as inappropriate

        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)?

      • Paul StephensonAdminPaul Stephenson (Admin, Red Gate) commented  ·   ·  Flag as inappropriate

        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.

      • ClaudioClaudio commented  ·   ·  Flag as inappropriate

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

      • JoshJosh commented  ·   ·  Flag as inappropriate

        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.

      • JamesJames commented  ·   ·  Flag as inappropriate

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

      Feedback and Knowledge Base