Download Query Analyzer Shortcuts (PDF)
| Shortcut | Function | Shortcut | Function | |
| ALT+BREAK | Cancel a query | CTRL+SHIFT+F2 | Clear all bookmarks | |
| ALT+F1 | Database object information | CTRL+SHIFT+INSERT | Insert a template | |
| ALT+F4 | Exit | CTRL+SHIFT+L | Make selection lowercase | |
| CTRL+A | Select all | CTRL+SHIFT+M | Replace template parameters | |
| CTRL+B | Move the splitter | CTRL+SHIFT+P | Open | |
| CTRL+C | Copy | CTRL+SHIFT+R | Remove comment | |
| CTRL+D | Display results in grid format | CTRL+SHIFT+S | Show client statistics | |
| CTRL+Delete | Delete through the end of the line | CTRL+SHIFT+T | Show server trace | |
| CTRL+E | Execute query | CTRL+SHIFT+U | Make selection uppercase | |
| CTRL+F | Find | CTRL+T | Display results in text format | |
| CTRL+F2 | Insert/remove bookmark | CTRL+U | Change database | |
| CTRL+F4 | Disconnect | CTRL+V | Paste | |
| CTRL+F5 | Parse query and check syntax | CTRL+W | Window selector | |
| CTRL+G | Go to line | CTRL+X | Delete | |
| CTRL+H | Replace | CTRL+Z | Undo | |
| CTRL+I | Index Tuning Wizard | F1 | Help for Query Analyzer | |
| CTRL+K | Display/hide execution plan | F2 | Move to next bookmark | |
| CTRL+L | Display execution plan | F3 | Repeat last search | |
| CTRL+N | New query window | F4 | Object Search | |
| CTRL+O | Connect | F5 | Execute a query | |
| CTRL+P | F6 | Switch between query and result panes | ||
| CTRL+R | Show/Hide results pane | F8 | Show/hide Object Browser | |
| CTRL+S | Save | SHIFT+F1 | Transact-SQL help | |
| CTRL+SHIFT+0 | Show options | SHIFT+F2 | Move to previous bookmark | |
| CTRL+SHIFT+C | Comment out code | SHIFT+TAB | Decrease indent | |
| CTRL+SHIFT+DEL | Clear the active Editor pane | SHIFT+F6 | Switch panes | |
| CTRL+SHIFT+F | Save results to file | TAB | Increase indent |
Download the PDF
Reference: Pinal Dave (https://blog.sqlauthority.com), MSDN
36 Comments. Leave new
Hi ,what does ‘N’ and ‘U’ in the following command stand for?also what is the necessity of Go in this ??? the following command executed even without the use of it?..
USE AdventureWorks;
GO
IF OBJECT_ID (N’dbo.AWBuildVersion’, N’U’) IS NOT NULL
DROP TABLE dbo.AWBuildVersion;
GO
thanks …
hi im trying to open mssms and load a store procedure from an specific data base using this script
sqlwb.exe [-S server_name[instance]] [-d dbname] [-U dbuser] [-P dbpass] [-E] [file_name[, sp_search]] [/?]
but is not working to load the sp but the mssms it does open
any sugestion?
What about CTRL-0 for entering a NULL value into a field when looking at grid view of a table.
Also, is there a CTRL-? shortcut for entering the current date and time into a datetime field similar to the CTRL-0 shortcut for the NULL value?
How to makes Query For find the table name and how can see the tables colom & row
Thanks
Hello Shiv,
You can query the table name in sys.Tables. For more details see my article: https://blog.sqlauthority.com/2008/08/06/sql-server-query-to-find-column-from-all-tables-of-database/
There are many way to see columns of a table as you can see columns in SSMS or by sp_help .
If this is not what you are looking for then please describe your question in detail.
Kind Regards,
Pinal Dave
is there anyway to disable the keyboard shortcut ctrl+e for Execute?
it is so close to ctrl+r , ctrl+d etc.. accidentally pressing it when working on a query could be disastrous..
Hi,
Is there any short cut to write “Select * from” in SQL 2005 or 2008. If such a short cut exists please let me know.
thanks and regards,
Arvind Dhiman
hello sir
i have one database .i have two tabie (emp), (salary). i have 300 rows in emp table.but i have no rows in salary
i have merge that two tables emp and salary
select * into salary from emp , i have added 100 rows in emp
i want a that second time i merge that two table emp or
salary only for 1oo rows not 300 rows
thankyou
pinal dave sir
when am writing a procedure or function in a query analyser sql server 2008 am not getting a intelligence popup which will guide to select the function,object or column or table names.
Do i have to install a specific service pack ??Please suggest me.
In the toolbar, goto query–>IntelliSense Enabled. Make sure it is enabled
CTRL+SHIFT+Q is used to add the database diagrams
Hi sir, If there are so many begin and end statements in proc what is shortcut to find end statements for perticular Begin.
If you use version 2008 with intellisense enabled, just go the END and delete D and type D, It will highlight the respective BEGIN
very useful shortcuts.
really cool keywoars thx for sharing