Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to refresh table data when in edit mode in latest versions of SQL Server Management Studio?

In SQL Server Management Studio, it is possible to open a table and see its contents, this is done by:

  • right clicking on the table
  • choosing Edit first N rows (where N is a parameter that defaults to 200)

In SQL Server 2008 R2 there was a button (I think a button with a exclamation mark icon if I remember correctly) that caused a refresh of the data on being clicked. This is very convenient in testing and development scenarios.

With the latest versions of SQL Server Management Studio (2016 at least), I cannot find that button anymore and so to refresh data I need to close the table and again select "edit first N rows" from the context menu.

Does anyone know how to refresh the data?

To express myself better:

this is the toolbar in ssms 2008R2 (I found this on a test server still at 2008R2):

2008r2 Toolbar

The "!" icon is the one I am not finding in ssms2016:

2016 Toolbar

like image 869
LaBracca Avatar asked Dec 14 '22 14:12

LaBracca


1 Answers

The default shortcut should be CTRL+R

You can check in Tools > Options > Environment > Keyboard :

enter image description here

like image 171
Andrea Avatar answered Dec 28 '22 10:12

Andrea