Select TOP N Rows missing from SSMS temporal table
My SSMS 17.5 does show the context-menu for "Select Top 1000 Rows" against a SQL Server 2016 temporal-enabled table on Enterprise Edition.
In SQL Server 2016 Express, via SSMS 17.5, I'm not able to see the "Select Top 1000 Rows" context menu.
This appears to be a purposeful decision by Microsoft within SQL Server Management Studio.
Just a workaround I found "by chance":
If using temporal tables, I always create the temporal table as mytable_history
.
So if you open the tree for that table it shows always at first the temporal table name. If you right-click the mouse on THAT temporal table it SHOWS the "select nnn rows and edit nnn rows"
So if you create the script it obviously contains the same column names - just with wrong "from"
, so I just delete that string "_history"
and execute that. And VOILA, I now HAVE my select on the table I wanted ...
Related issue in SQL Server forum/suggestion pages, please vote:
https://feedback.azure.com/forums/908035-sql-server/suggestions/32898913-ssms-right-click-menu-option-to-design-tables