How to change key binding for 'Execute Current Statement'

larus

I would like to change the key binding for 'Execute Current Statement' from the default 'Shift+F5' to 'Ctrl+Enter'. How can I do that? I'm using SQL Prompt 7.3.

Jessica R

Hi and thanks for your post!

It's unfortunately not possible to customize SQL Prompt keyboard shortcuts at the moment, but we do have a request for this on our userforum: https://redgate.uservoice.com/forums/94 ... -shortcuts

Can you please vote on this feature to add priority to the request?

torsten.strauss

It is possible for sure.
Just go to Tools / Option / Keyboard ...
Search for OtherContextMenus.SQLFilesEditorContext.ExecuteCurrentStatement and assign Ctrl + Enter as a global shortcut key.
This will work for SSMS and Visual Studion.

larus

Thanks, it worked when I assigned it to SQL Query Editor! Now both works (Shift+F5 and Ctrl+Enter) for executing the current statement.