Keyboard Shortcuts

The below are shortcut keys that will work with SQLYog. It is highly recommended that all users keep a good reference of the below short cut keys and/or try to memorize the below keys. Doing so will dramatically increase your productivity.

Keyboard Shortcuts Command
Ctrl+M Create A New Connection
Ctrl+N Create A New Connection With Current Connection Properties
Ctrl+F4/Ctrl+W Disconnect The Current Connection
Ctrl+Tab Switch to Next Connection
Ctrl+Shift+Tab Switch to Previous Connection
Ctrl+1...8 Select Connection (1 to 8)
Ctrl+9 Select Last Connection
Object Browser
F5 Refresh Object Browser (Default)
Ctrl+B Set Focus On Object Browser
Ctrl+Shift+B Set Focus On Object Browser Filter
Shift+{-} Collapse All in Object Browser
SQL Window
Ctrl+T New Query Editor
Alt+F2 Rename Query Editor
Ctrl+E Set Focus On SQL Window
Ctrl+Y Redo
Ctrl+Z Undo
Ctrl+X Cut
Ctrl+V Paste
Ctrl+H Replace
Ctrl+G Go to
Ctrl+O Open File In New Tab
Ctrl+Shift+O Open File In Same Tab
Ctrl+Shift+U Make Selection Uppercase
Ctrl+Shift+L Make Selection Lowercase
Ctrl+Shift+C Comment Selection In SQL Window
Ctrl+Shift+R Remove Comment From Selection
Ctrl+Shift+T Insert Templates
Ctrl+Enter List All Tags
Ctrl+Space List Matching Tags
Query Execution
F8 Execute Current Query And Edit Result
F9 Execute Current Query (Default)
Ctrl+F9 Execute Selected Query(s) (Default)
SQL Formatter
F12 Format Current Query
Ctrl+F12 Format Selected Query
Shift+F12 Format All Queries
Paste SQL Statements
Alt+Shift+I Insert Statement
Alt+Shift+U Update Statement
Alt+Shift+D Delete Statement
Alt+Shift+S Select Statement
F11 Insert Update Dialog
Ctrl+R Set Focus To The Active Tab In Result Pane
Ctrl+L Switch Result Window/Table Data Between Grid/Text Mode or Form View/text
Ctrl+Alt+L Switch Result Window/Table Data Between Grid and Form View
Ctrl+Alt+C Export Table Data As CSV, Excel, SQL etc...
Ctrl+Alt+E Backup Data As SQL Dump
Ctrl+Shift+M Import Data From CSV
Ctrl+Shift+E Export Resultset
Alt+1...8 Select Tab In Result Window (1 to 8)
Alt+9 Select Last Tab in the Result Window
Ctrl+Shift+1 Show/Hide Object Browser
Ctrl+Shift+2 Show/Hide Result Pane
Ctrl+Shift+3 Show/Hide Query Window
Ctrl+D Create Database
F6 Alter Database/Table Structure/Index/View/Store Proc/Function/Trigger/Event
F2 Rename Table/View/Trigger/Event
Shift+Del Truncate Database/Table
F7 Manage Index Window
F10 Relationships/Foreign Keys
Ctrl+Alt+R Reorder Column(s)
Alt+S Save Table
Alt+R Revert Changes Made To Table Schema
Ctrl+Alt+T Table Diagnostics
Ctrl+Alt+F Flush Dialog
Ctrl+Shift+Alt+S Create Schema For Database In HTML
Ctrl+Shift+Q Restore From SQL Dump
Ctrl+Alt+W Database Synchronization Tool
Ctrl+Q Schema Synchronization Tool
Ctrl+Alt+O Migration Toolkit
Ctrl+Alt+N SQL Scheduler and Reporting Tool
Ctrl+Alt+S Scheduled Backup Wizard
Other Tabs
Ctrl+K Query Builder
Ctrl+Alt+D Schema Designer
Ctrl+Shift+D Data Search
Ctrl+Shift+I Info Tab
Ctrl+Shift+H History Tab
User Manager
Ctrl+U Add A New User
Ctrl+Alt+U Edit User
Ctrl+Shift+W Manage Privileges
Ctrl+Shift+F Add Current SQL To Favorites
Alt+Shift+L Change Language
F1 Help
Ctrl+C Copy
Ctrl+A Select All
Ctrl+F Find (SQL Window/Result Window And Table Data In Text Mode/Blob Viewer)
F3 Find Next (SQL Window/Result Window And Table Data In Text Mode)
Ctrl+S Save
Ctrl+PgUp Switch To Previous Tab
Ctrl+PgDown Switch To Next Tab
DEL Delete Selected
Alt+F5 Refresh Table Data Tab
Alt+L Close Tab
Alt+F4 Exit