Important Keyboard Shortcuts In SQL Server 2014

SQL Server Management Studio (SSMS) has the functionality of more than 100 keyboard shortcuts. For every SQL Server user or database administrator the use of Keyboard shortcuts will surely impact on the time saving and improving productivity in daily life.

The following are the most frequently used SSMS keyboard shortcuts which will make programming life more easy and efficient as in the following,

  1. To view Object Explorer: Use F8,

    object explorer

  2. Open a new Query Window: Instead of clicking on New Query use (Ctrl + N),

    1

  3. Moving between various Query Windows Opened tabs: Use (Ctrl + Tab),

    2

  4. Show or Hide Results pane: Use (Ctrl + R),

    3

  5. To execute Selected Query: Use Ctrl + E or F5,

    4

  6. To cancel a running query with lengthy output:

    Use  Alt + Scroll Lock or Alt + Break.

  7. Changing Query cases: For Uppercase: Use Ctrl + Shift + U, and
                                              For lowercase: Ctrl + Shift+ L



  8. To see Execution plan of any query: Use Ctrl + L,

    6

  9. To see list of function variables list: Use Ctrl + Space bar.

    7

  10. To Go to Query Line: Use Ctrl + G

    8

  11. To make query comment or undo comment type: Use Ctrl + K + C and Ctrl + K + U for undo comment.

    9

  12. To view SQL Server database objects and properties: Use Alt + F1,

    10

  13. Display Template Explorer: SSMS built-in T-SQL templates to perform common management tasks such as backups and creating and dropping SQL Server databases and objects. Use CTRL+ALT+T,

    11

Up Next
    Ebook Download
    View all
    Learn
    View all