Keyboard shortcuts

Question

I'd like to create a consistent experience between ssms 2012 and vs ssdt with keyboard shortcuts and this is proving difficult (!!).

For example can anyone tell me how to set the keyboard shortcut for scripts - Move to next/prev pane (t-sql, message and results). None of the standard keyboard commands seem to control this and it is proving RSI inducing. Could someone let me know what the keyboard command is for this as it doesn't seem to be the standard t-sql one.

Answer 1

Hi Brett,

We've created a keyboard profile with SSMS mappings, which sounds like a solution to your problems.  Details in the following blog post: http://blogs.msdn.com/b/ssdt/archive/2012/03/07/using-ssms-keyboard-mappings-in-ssdt.aspx

-Janet Yeilding

Answer 2

Hi Janet, I had seen this article but from the list of the keyboard shortcuts it didn't appear to provide the item(s) that I was looking for. It actually only provides a very small set of keyboard shortcuts. Having now installed the pack I can see that I was correct.

The 2 most commonly used keyboard shortcust in ssms is change database (Alt-D) and switch pane (F6).

Neither of these appear to be possible in ssdt.

I really hope there is a command somewhere that allows it but if not this is a big oversight imo.

Answer 3

CTRL + D, N will switch panes (http://social.msdn.microsoft.com/Forums/en-US/ssdt/thread/1c02a0df-df5d-4c75-85dc-19660504a09f) but there isn't an SSDT shortcut to change database

Answer 4

Thanks Janet, aha that does work but is clearly not very quick to execute do that such a command demands.

Note to others that you have to release the ctrl before you hit n which just makes it much more difficult to use.

Please could I suggest that this is added as a selectable command in VS Keyboard list so I can use the currently useless F6 in VS which is basically just a reduced functionality Ctrl-Tab to a useful F6! You could then add this command to the sql developer keyboard profile!

Thanks!