Here are few SQL query analyzer keyboard shortcuts to save your time and to make you smart among your peers. These are valid from SQL Server 2005.

The most common ones

1. F5

Executes all or selected queries in the query window.

2. F4

Opens properties dialog box

1_sql query analyzer keyboard shortcuts

3. F8

Object Explorer window.

2_sql query analyzer keyboard shortcuts

4. F7

Object explorer details window.

3_sql query analyzer keyboard shortcuts

5. Ctrl + Alt + G

Registered Servers Window

4_sql query analyzer keyboard shortcuts

6. Ctrl + Alt + T

Template Explorer window

5_sql query analyzer keyboard shortcuts

7. Alt + F1

Executes sp_help

8. Ctrl + 1

Executes sp_who
9. Ctrl + 2

Executes sp_lock

10. Custom Query shortcuts

Additional custom query keyboard shortcuts can be added to – Click Tools | Options | Keyboard | Query shortcuts. Add the custom shortcuts in the query shortcut grid

6_sql query analyzer keyboard shortcuts

Do add the shortcut you use mostly to this list. Will be back with more shortcuts.

 

Regards

Ahmad Osama

Like us on FaceBook Join the fastest growing SQL Server group on FaceBook

Follow me on TwitterFollow me on FaceBook