Keyboard key to Toggle between query and results pane

  • Comments posted to this topic are about the item Keyboard key to Toggle between query and results pane

    Thanks

  • Also SHIFT+F6. These hot keys are windows standard.

  • Nice question, thanks.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • Good One!

    ---------------------------------------------------
    "Thare are only 10 types of people in the world:
    Those who understand binary, and those who don't."

  • Good one, thank you for the post.

    Agreed F6 and SHIFT+F6 - both works. But they are not the same.

    F6 in SSMS is "move to the next pane" - [if the cursor is in the query pane, it moves ahead to the result pane]

    SHIFT+F6 in SSMS is "move to the previous pane"

    Try this: type "SELECT 1" in the query window, execute, you will see result pane and also message pane. Now try F6 and SHIFT+F6 to see the direction of the focus.

    ww; Raghu
    --
    The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.

  • Raghavendra Mudugal (5/30/2014)


    Good one, thank you for the post.

    Agreed F6 and SHIFT+F6 - both works. But they are not the same.

    F6 in SSMS is "move to the next pane" - [if the cursor is in the query pane, it moves ahead to the result pane]

    SHIFT+F6 in SSMS is "move to the previous pane"

    Try this: type "SELECT 1" in the query window, execute, you will see result pane and also message pane. Now try F6 and SHIFT+F6 to see the direction of the focus.

    Of course, they just differ in direction (next/previous)! But if you are in grid mode with ONE F6 go to result pane, the same with TWO SHIFT+F6 (first goes to the message pane and the second to the result pane).

  • Thanks Hardik for question.

    However with the introduction of new keyboard having fn key in place.Microsoft should also change their doumentation.

    As here it would be (fn + f6) key would be the answer.

    --rhythmk
    ------------------------------------------------------------------
    To post your question use below link

    https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
    🙂

  • Strictly speaking f6 isn't a toggle

    It will cycle through all open panes not just those two and if you don't have the results pane visible it won't show it.

    You could argue that ctrl-R would better fit as an answer as that is a toggle and will show/hide the results pane.

  • Easy one like for Friday 🙂

    Igor Micev,My blog: www.igormicev.com

  • I would agree, ctl + R is the correct answer.

  • rhythmk (5/30/2014)


    Thanks Hardik for question.

    However with the introduction of new keyboard having fn key in place.Microsoft should also change their documentation.

    As here it would be (fn + f6) key would be the answer.

    +10

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Thanks for the question.

    The options of fn+f6 and shft+f6 are great for toggling between the query, messages, and results tabs.

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • Thanks Hardik. Nice question.

  • This was removed by the editor as SPAM

Viewing 15 posts - 1 through 15 (of 19 total)

You must be logged in to reply to this topic. Login to reply