In SQL Server Management Studio, it is possible to open a table and see its contents, this is done by:
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):
The "!" icon is the one I am not finding in ssms2016:
The default shortcut should be CTRL+R
You can check in Tools > Options > Environment > Keyboard :
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With