SQL Server – Select TOP N Rows Missing from SSMS Temporal Table

sql serversql-server-2016sql-server-2017ssms

I am using temporal tables within my database and when I right click on my table in Management Studio 2017 (v17.4 14.0.17213.0) I do not see the Select Top 1000 Rows in the context menu (there is no problem with non temporal tables)

ssms missing select top

Any ideas how to get this context menu back? I have a feeling it is to do with the version of SQL Server I am running (SQL 13.1.4001.0 Express Edition)

Best Answer

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.

enter image description here

In SQL Server 2016 Express, via SSMS 17.5, I'm not able to see the "Select Top 1000 Rows" context menu.

enter image description here

This appears to be a purposeful decision by Microsoft within SQL Server Management Studio.

Related Question