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 |
| Connection | |
| 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 |
| Result | |
| 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 |
| Show/Hide | |
| Ctrl+Shift+1 | Show/Hide Object Browser |
| Ctrl+Shift+2 | Show/Hide Result Pane |
| Ctrl+Shift+3 | Show/Hide Query Window |
| Database/Table | |
| 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 |
| PowerTools | |
| 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 |
| Favorites | |
| Ctrl+Shift+F | Add Current SQL To Favorites |
| Language | |
| Alt+Shift+L | Change Language |
| Other | |
| 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 |