Jump between COLUMN/VALUE within INSERT statement

When editing large INSERT statements with big number of columns involved it is useful to know the corresponding COLUMN of the currently edited VALUE. And vice versa: sometimes you want to locate the corresponding VALUE within values list for the current COLUMN. The solution is to use "Jump between COLUMN and VALUE" command in SQL Editor context menu.

jump between column and value in insert statement

You can also use universal "JUMP" shortcuts Ctrl+Shift+Up Arrow to navigate "UP" (from VALUE to COLUMN) or Ctrl+Shift+Down Arrow to navigate "Down" (from COLUMN to VALUE). For better visibility the corresponding COLUMN/VALUE pairs are highlighted

highlighted column/value pairs

These shortcuts are shared with GoTo BEGIN/END functionality and act depending on the current cursor placement.