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
3. F8
Object Explorer window.
4. F7
Object explorer details window.
5. Ctrl + Alt + G
Registered Servers Window
6. Ctrl + Alt + T
Template Explorer window
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
Do add the shortcut you use mostly to this list. Will be back with more shortcuts.
Like us on FaceBook | Join the fastest growing SQL Server group on FaceBook
