Create Short-Cuts in SQL Server Management Studio Query Window

Using short-cuts in SQL Server Management Studio query windows may ease your job while editing and writing sql codes and statements.
One of the short-cuts that is defined by default and very well-known is Alt+F1 key combination. Alt-F1 is the short-cut of "sp_help" system stored procedure.
Alt+F1 key combination runs the sp_help stored proc sp which can be used to view the table columns, constraints, indexes, etc. of the table that is highlighted.
I generally use the system stored procedure sp_helptext that I use to see the text of the stored procedure that is highlighted in the query window.
Since I use sp_helptext frequently, I defined Ctrl+F1 key combination as a short-cut for sp_helptext sp.
It is easy to define short-cuts for the query editor window. Just go to menu Tools then Options... to open the screen where you can set different sets of options for the Microsoft SQL Server Management Studio.

If you open the Keyboard options in the Environment directory, you can see all query shortcuts defined.

And I defined the shortcut Ctrl+F1 for running the stored procedure sp_helptext.
Do not forget to open a new query window in order to use the new shortcut.

Related SQL Resources

SQL Server Articles

SQL Server Tools

SQL Blog

SQL Server 2008 Blog

Certification Exams Blog

Reporting Services Blog

Analysis Services Blog

MS SQL Server Forums

Free Exam Vouchers