Use the following keyboard shortcuts when working with data in Data Editor or Data Viewer of a SQL document.
The default keyboard mapping scheme for the shortcuts is Microsoft SQL Server Management Studio.
| Name | Keyboard shortcuts | Description |
|---|---|---|
| AutoSearchMode | Ctrl+I | Enables the auto-search mode. |
| CopyWithHeader | Ctrl+Shift+C | Copies data with the column header. |
| DeleteRow | Ctrl+Delete | Deletes the selected row from the data grid. |
| FilterEqual | Ctrl+Q | Filters by equality. |
| NewRow | Insert | Inserts a new record into the grid. |
| RefreshData | F5 Ctrl+R |
Refreshes the data view. |
| SelectColumn | Ctrl+Space | Selects the column in the grid. |
| SelectRow | Shift+Space | Selects the row in the grid. |
| SetToNull | Ctrl+0 | Inserts a NULL value into the cell. |
| ShowDataViewer | Ctrl+W, R | Opens Data Viewer. |
| SaveData | Ctrl+S | Saves data in Data Viewer. |
| CopyData | Ctrl+C | Copies data in Data Viewer. |
| HexadecimalView | Ctrl+1 | Represents data in a hexadecimal view. |
| TextView | Ctrl+2 | Represents data in a text view. |
| XMLView | Ctrl+3 | Represents data in an XML view. |
| HTMLView | Ctrl+4 | Represents data in an HTML view. |
| WebView | Ctrl+5 | Represents data in a web view. |
| RichTextView | Ctrl+6 | Represents data in a rich text view. |
| PDFView | Ctrl+7 | Represents data in a PDF view. |
| JSONView | Ctrl+8 | Represents data in a JSON view. |
| ImageView | Ctrl+9 | Represents data in an image view. |
| FitImage | Ctrl+B | Scales images to fit the window. |
| SpatialView | Ctrl+Alt+0 | Represents data in a spatial view. |
1. Select Tools > Options.
2. Select Environment > Keyboard.
3. Under Apply the following additional keyboard mapping scheme, select a different scheme.
When you change the scheme, the shortcuts update automatically.