SSDT - Toggle Between Code and Results Panes with Keyboard

Question

Hi.

I am trying to find a keyboard shortcut equivalent for the old F6 for toggling between the results and code panes in the new SSDT TSQL Editor, but cannot find the right entry in the shortcuts list.  I was able to find the Execute as SQL.TSqlEditorExecuteQuery and assign it to F5, but not for panes.

The whole functionality of choosing between either splitting the current pane for results, or displaying a separate pane, as well as choosing where the tabs for those panes should be - on top or on the bottom - seems to be gone.

Is it, or I am not finding the right place?

Thank you!

Answer 1

SQL.TSqlEditorToggleResultsPane is the equivalent of the "Collapse Pane" tiny icon, which is roughly equivalent to the functionality in question.

I am hoping that in time all the old capabilities will be back :)

Answer 2

Thanks for your question, Rafael.

There are a couple of ways to get to the functionality you're looking for:

1. The KB shortcut "CTRL + D, N" will cycle between the visible editor pane and the message/results tabs associated with it.  This command will both display the editor pane and give focus to it, allowing you to page through your results, message, or TSQL content.  We do not currently support overriding this shortcut.
2. You can change the position of the results pane (top or bottom, left or right) by using the "Swap" control on the results tab, which looks like a set of up and down arrows in the default configuration of a top/bottom split for editor results.  This control will also switch the results/editor panes between left and right screens if you've changed the option to display them side-by-side.  None of these settings persist across editor tabs, however, so you'll need to set this up in each new editor you open. 

Please let me know if these settings meet  your needs, or if I've misunderstood your question.

Thanks,

Aaron