Use the following shortcut key combinations when working with data in the Data Editor or data view of a SQL document in Event Profiler.
| Command Name | Shortcut Keys | Action |
|---|---|---|
| AutoSearchMode | CTRL+I | Enable the auto-search mode |
| CopyWithHeader | CTRL+SHIFT+C | Copy data with the column header |
| DeleteRow | CTRL+DELETE | Delete the currently selected row in the data grid |
| FilterEqual | CTRL+Q | Quick filtering by equal value |
| NewRow | INSERT | Insert a new record into the grid |
| RefreshData | F5 | Refresh the data view |
| RefreshData | CTRL+R | Refresh the data view |
| SelectColumn | CTRL+SPACE | Select the entire column in the grid |
| SelectRow | SHIFT+SPACE | Select the entire row in the grid |
| SetToNull | CTRL+0 | Insert a NULL value into the current cell |
| SetToNull | CTRL+NUMPAD 0 | Insert a NULL value into the current cell |
| ShowDataViewer | CTRL+W, R | Open the Data Viewer |
| SaveData | CTRL+S | Save data in the Data Viewer |
| CopyData | CTRL+C | Copy data in the 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 |
The default keyboard mapping scheme for the shortcuts above is Microsoft SQL Server Management Studio. It can be changed on the Tools menu > Options > Environment > Keyboard > Apply the following additional keyboard mapping scheme. Whenever you change the scheme, the shortcuts will be changed accordingly.