DataGrid behavior
Keyboard Shortcuts
The results grid supports keyboard shortcuts for common actions when it has focus.
Shortcuts
Section titled “Shortcuts”| Action | Windows/Linux | macOS |
|---|---|---|
| Jump to column | Ctrl + Shift + O or Ctrl + F12 | Cmd + Shift + O or Cmd + F12 |
| Save changes | Ctrl + S | Cmd + S |
| Refresh | Ctrl + R | Cmd + R |
| Undo | Ctrl + Z | Cmd + Z |
| Redo | Ctrl + Y or Ctrl + Shift + Z | Shift + Cmd + Z or Cmd + Y |
| Add row | Ctrl + N | Cmd + N |
| Add row from the last cell (editable tables) | Tab | Tab |
| Select row | Shift + Space | Shift + Space |
| Select column | Ctrl + Space | Ctrl + Space |
| Duplicate selected cells/rows | Ctrl + Shift + D | Shift + Cmd + D |
| Delete selected rows | Ctrl + Backspace or Ctrl + Delete | Cmd + Backspace or Cmd + Delete |
| Copy | Ctrl + C or Ctrl + Insert | Cmd + C |
| Cut (copies, then clears the editable cells) | Ctrl + X | Cmd + X |
| Copy qualified table name (table tabs and the connections tree) | Ctrl + Alt + C | Cmd + Option + C |
| Transpose rows and columns | Ctrl + T | Cmd + T |
| Focus WHERE filter | Ctrl + Shift + F | Cmd + Shift + F |
| Quick search | Ctrl + F | Cmd + F |
| Move cell focus | Assign in Keyboard Shortcuts | Ctrl + H / J / K / L |
| Chart selected cells | Ctrl + G | Cmd + G |
| Close detail grid | Esc | Esc |
Changing shortcuts
Section titled “Changing shortcuts”The grid actions are listed in VS Code’s Keyboard Shortcuts editor, where you can change their keys. Open it with Ctrl + K, Ctrl + S (Cmd + K, Cmd + S on macOS) and search for “DBCode”. Each grid action appears as DBCode: Grid: followed by its name, for example DBCode: Grid: Save Changes.
By default, Ctrl + H / J / K / L move cell focus left, down, up and right on macOS. On Windows and Linux, assign your own keys to DBCode: Grid: Move Left, Move Down, Move Up and Move Right in Keyboard Shortcuts.
Jump to column
Section titled “Jump to column”Jump to column opens a small popup listing every column in the grid. Type part of a column name to filter, use the arrow keys to move the highlight, and press Enter to scroll that column into view and focus it. Hidden columns appear dimmed in the list; picking one makes it visible again. Press Esc to close the popup without jumping.