Creating Query Shortcuts in SQL Server Management Studio

You can create shortcuts for commonly used queries in SQL Management Studio. Some of the shortcuts are predefined, like  "Alt + F1" will execute "sp_help" and "Ctrl + 1" will execute "sp_who". You can create new shortcuts for your own queries.

To create a new shortcut,

Go to Tools > Options > Environment > Keyboard > Query Shortcuts

For example, you can create a shortcut for:

Syntax

"Ctrl + 3 " : SELECT * FROM  (single space after from keyword)