SQL SERVER – Query Analyzer Shortcuts

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 Print 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

SQL Download, SQL Shortcut, SQL Utility
Previous Post
SQL SERVER – Query to find number Rows, Columns, ByteSize for each table in the current database – Find Biggest Table in Database
Next Post
SQL SERVER – SQL Joke, SQL Humor, SQL Laugh

Related Posts

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

    Reply
  • thanks …

    Reply
  • 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?

    Reply
  • 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?

    Reply
  • shiv kumar sharma
    December 3, 2009 6:59 pm

    How to makes Query For find the table name and how can see the tables colom & row

    Thanks

    Reply
  • 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..

    Reply
  • Arvind DHiman
    April 28, 2010 3:24 pm

    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

    Reply
  • 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

    Reply
  • 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.

    Reply
  • CTRL+SHIFT+Q is used to add the database diagrams

    Reply
  • Hi sir, If there are so many begin and end statements in proc what is shortcut to find end statements for perticular Begin.

    Reply
    • If you use version 2008 with intellisense enabled, just go the END and delete D and type D, It will highlight the respective BEGIN

      Reply
  • very useful shortcuts.

    Reply
  • really cool keywoars thx for sharing

    Reply

Leave a ReplyCancel reply

Exit mobile version