SQL Server administration and T-SQL development, Web Programming with ASP.NET, HTML5 and Javascript, Windows Phone 8 app development, SAP Smartforms and ABAP Programming, Windows 7, Visual Studio and MS Office software
Development resources, articles, tutorials, code samples, tools and downloads for ASP.Net, SQL Server, Reporting Services, T-SQL, Windows, AWS, SAP HANA and ABAP


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.

tools-options-environment-keyword-new-query-window





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

  • Alt+F1 is for sp_help
  • Ctrl+1 is for sp_who
  • Ctrl+2 is for sp_lock


  • 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.



    SQL Server

    SQL Server 2019 Installation
    download SQL Server 2019
    download SQL Server 2017
    download SQL Server 2016
    download SQL Server 2014
    download SQL Server 2012
    MacOS ve SQL Server 2019


    Copyright © 2004 - 2021 Eralper YILMAZ. All rights reserved.