This article contains a list of some keyboard shortcuts of DatAdmin database administration tool
| Shortcut | Command | Edition required |
|---|---|---|
| Global shortcuts | ||
| Ctrl+N | New file or connection (wizard) | No limit |
| Ctrl+O | Open file | No limit |
| Ctrl+S | Save currently open file | No limit |
| Ctrl+Shift+S | Save file to specific location | No limit |
| Ctrl+Q | New query on current connection | No limit |
| Ctrl+G | Generate SQL (depends on selected object) | No limit |
| Ctrl+F4 | Close current window | No limit |
| F1 | Online help | No limit |
| Connection tree | ||
| F5 | Refresh current node | No limit |
| Shift+mouse double click | On connection: open new query | No limit |
| Ctrl+mouse double click | Open object dashboard | No limit |
| F2 | Rename object | No limit |
| F4 | On table - edit table structure | No limit |
| Delete | Delete selected object | No limit |
| Query editor | ||
| F9 | Execute query (if part of text is selected, execute only selected text) | No limit |
| Shift+F6 | Execute to cursor | No limit |
| Ctrl+F6 | Execute to cursor | No limit |
| F6 | Execute current line | No limit |
| Ctrl+F | Find text | No limit |
| F3 | Find next text with last search criteria | No limit |
| Ctrl+H | Find & replace text | No limit |
| Ctrl+Shift+A | Comment / uncomment | No limit |
| Ctrl+Shift+I | Increase indentation | No limit |
| Ctrl+Shift+U | Decrease indentation | No limit |
| Ctrl+J | Insert SQL Join | Professional |
| Ctrl+Space | Show code completion window | Professional |
| Table data | ||
| Ctrl+F | Quick search (than Enter: perform search) | No limit |
| Ctrl+E | Show referenced tables | Professional |
| Ctrl+D | Duplicate current row | No limit |
| Ctrl+R | Revert row changes | No limit |
| Ctrl+Insert | Insert new row | No limit |
| Ctrl+Delete | Delete current row | No limit |
| Ctrl+Enter | Show current cell editor (autodetect format). Than Escape-close editor | No limit |
| Ctrl+0 | Set NULL to current cell | No limit |
| F5 | Refresh data | No limit |
| Ctrl+S | Save modifications to database | No limit |
| Control of dockable windows (view menu) - global | ||
| Ctrl+Alt+P | Show running backgrond processes (backups, copy-database, etc.) | No limit |
| F11 | Show Properties window (dashboard designer) | Professional |
| Ctrl+Alt+T | Show Toolbox window (dashboard designer) | Professional |
| Ctrl+Alt+D | Show data browser | No limit |
| Alt+0 | Show window list | No limit |
| Ctrl+Alt+L | Show log window | No limit |
| Ctrl+Alt+N | Show active connections | No limit |
| Ctrl+Alt+P | Show running backgrond processes (backups, copy-database, etc.) | No limit |
| Ctrl+Alt+T | Show connection tree | No limit |
| Ctrl+Alt+S | Show addons manager | No limit |
| Ctrl+Alt+Q | Show SQL scripts folder | No limit |
| Ctrl+Alt+F | Show favorites manager | No limit |
| Ctrl+Alt+O | Show object summary window | No limit |
| Ctrl+Alt+E | Show scheduled tasks window | Professional |
| Ctrl+Alt+J | Show jobs manager | Professional |
| Ctrl+Alt+H | Show query history | Professional |
Post new comment