SQL Query Analyzer: SQL Query Analyzer is a free-form text editor for keying used to monitor the SQL servers and help users analyze database objects for improving database performance. It is used to view the live sessions of the activity on your running SQL server database.
Furthermore, it also has an “Object Browser” that you can use to browse and edit tables, view, and store procedures. You can also display a list of common SQL server functions and their parameters.
If you want to open the Query Analyzer, you can use Enterprise Manager to the database to work with it.
In this article, you will learn shortcuts for the SQL Query Analyzer. Use these shortcuts to save your working time. Let’s get into this article.
Last Updated on Feb11, 2022.
General Shortcut Keys:
In the below table, you will learn shortcuts and their functions of SQL Query Analyzer. Kindly use these shortcuts properly.
Table 1:
| Shortcut | Function |
|---|---|
| Ctrl+F2 | This shortcut is used to insert or remove a bookmark. |
| Ctrl+O | use this shortcut to connect the data. |
| Ctrl+F4 | If you want to disconnect and close the windows, you can use this shortcut. |
| Ctrl+C | It is used to copy the data. |
| Ctrl+X | In order to cut the data, you can use this shortcut. |
| Ctrl+Del | Make use of this shortcut to delete through the data line. |
| Ctrl+F | By using this shortcut, you can find the data. |
| Ctrl+G | Helps to go to the line number. |
| Ctrl+V | Used to paste the data. |
| Ctrl+H | It will help to replace the data. |
| Ctrl+A | In order to select all the data, you can use this shortcut. |
| Ctrl+Z | Use this shortcut to undo the action. |
| Ctrl+W | This shortcut is used to go to the Window selector. |
| Ctrl+N | Make use of this shortcut to create a new query window. |
Table 2:
| Shortcut | Function |
|---|---|
| Ctrl+F5 | It is used to parse the query and check syntax. |
| Ctrl+P | This shortcut is used to print the file. |
| Ctrl+R | If you want to show the results’ pane, you can use this shortcut. |
| Ctrl+S | Make use of this shortcut to save the file. |
| Ctrl+L | In order to display the estimated version, you can use this shortcut. |
| Ctrl+K | Use this shortcut to display the execution plan, you can use this shortcut. |
| Ctrl+I | Used to index the Tuning Wizard. |
| Ctrl+U | If you want to use the database, you can use this shortcut. |
| F2 | Make use of this shortcut to move to the next bookmark. |
| Tab | It is used to increase the indent. |
| F3 | In order to repeat the last search or find the next, you can use this shortcut. |
| F1 | Used to get the help for Query Analyzer. |
| F6 | use this shortcut to switch between query and result panes. |
| F4 | To make the object, you can use this key. |
Table 3:
| Shortcut | Function |
|---|---|
| Ctrl+Shift+F2 | This shortcut is used to clear all bookmarks. |
| Ctrl+Shift+Del | By using this shortcut, you can clear the active editor pane. |
| Ctrl+Shift+C | It is used to comment out code. |
| Ctrl+Shift+L | Use this shortcut to make the selection in lowercase. |
| Ctrl+Shift+U | If you want to make the selection in uppercase, you can use this shortcut. |
| Ctrl+Shift+Insert | Used to insert the template. |
| Ctrl+Shift+M | This shortcut is used to replace the template parameters. |
| Alt+Break | Make use of this shortcut to cancel a query. |
| Alt+F1 | In order to get the database object information, you can use this shortcut. |
| Shift+Tab | It is used to decrease the indent. |
| Shift+F1 | To get help for the selected Transact-SQL statement. |
| Shift+F6 | This shortcut is used to switch the panes. |
Verdict:
You can use these shortcuts for both Windows 10 and Windows 11. Make sure to use these shortcuts properly.
From this article, you will learn a List of SQL Query Analyzer Keyboard Shortcuts. Thank you for reading this article. I hope this article is helpful!. If you have any questions or doubts regarding this article, please share with us in the comment section.