Keyboard shortcuts can help accelerate diagram navigation and editing. Some of the common shortcuts are listed here for reference (and always available from the help menu in SqlDBM).
Reviewing shortcuts from within SqlDBM
The list of shortcuts can be accessed at any time from the "Help menu" in the left panel in SqlDBM.
Common shortcuts
Save | Ctrl+S (⌘+S) |
Undo | Ctrl+Z (⌘+Z) |
Redo | Ctrl+Shift+Z (⌘+⇧+Z) |
Select all objects on the diagram | Ctrl+A (⌘+A) |
Multiselect | Shift (⇧) |
| Add objects to selected area | Ctrl (⌘) |
| Add selected area to multiselect | Shift (⇧) |
| Select all columns (click on any columns first) | Ctrl+A (⌘+A) |
Diagram
Add table | Insert |
Add note | Ctrl+Insert |
Create diagram with selected part of the schema | Hold Ctrl (⌘) and click “+” on the diagram tab |
Add non-identifying relationship | Shift+Insert |
Add identifying relationship | Ctrl+Shift+Insert or hold Ctrl (⌘) when dragging relationship |
Edit table, view, procedure, function, note, etc. | Enter (↵) |
Delete object | Delete (⌫) |
Copy object | Ctrl+C (⌘+C) |
Paste object | Ctrl+V (⌘+V) |
Copy column | Hold Ctrl (⌘) and move column |
| Multi-select (on Explorer and Diagrams) | Ctrl (⌘) + Click |
| Multi-select range (on Explorer and Diagrams) | Shift (⇧) + Click |
View mode
Table view | Ctrl+1 (⌘+1) |
PK/AK view | Ctrl+2 (⌘+2) |
Keys view | Ctrl+3 (⌘+3) |
Physical view | Ctrl+4 (⌘+4) |
Description view | Ctrl+5 (⌘+5) |
Logical View | Ctrl+6 (⌘+6) |
Forward Engineering
Copy script | Ctrl+C (⌘+C) |
Generate script | Ctrl+Enter (⌘+↵) |