The following are the Microsoft SQL Server keyboard shortcuts.

  1. To Run Microsoft SQL Server:

    • Press Windows+R
    • Type ssms
    • Press the OK button



  2. Control+G: to go to the desired line number and display line number in the query editor window.

    Go to Tools -> Options.



    It will display numbers as in the following image.

    For example:



  3. Control+E: Executes the query.

    Select the query you want to execute and then press Control+E.

  4. Control+L: Cost Estimation.

    Select the query you want to execute and then press Control+L.

    For example:



  5. Control+R: Hide/show the Result Pane.

  6. Control+N: New Query Window.

  7. Control+Shift+U: Convert text to UPPERCASE.

    Select the text you want to convert and then press Control+Shift+U.

  8. Control+Shift+L: Convert text to lowercase.

    Select the text you want to convert and then press Control+Shift+L.

  9. Control+Shift+Del: Clears the active query window.

    It clears the contents of the active window.

  10. Control+U: Use databse.

    Press Control+U, then your mouse focus will go to the database dropdown as in the following.

    For example:



    And then you can use the up and down arrow keys or type the text to choose the database.

  11. Control+T: displayss the result in text format.

    Press Control+T and then execute the query. It will show the result as follows.

    For example:



  12. Control + D: To display the result in Grid format.

    And to display the result in grid (default format) press Control+D and then execute the query.

  13. Control+ Left/Right Arrow: To move the cursor to the next word.

  14. Control+Shift+ Left/Right Arrow: To move and select the next word.

  15. Alt+Shift+ Left/Right/Down Arrow: To select the text that is usually not possible using the mouse as in the following.

    For example:



  16. Alt+F1

    To view the table definition.

    Select the table name and then press Alt+F1.

    For example: