8

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)

  • Related: 1 and 2 – Alexei Mar 2 '18 at 11:34
5

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.

3

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

  • The linked feedback.azure.com bug is for the "Design" menu entry (SSMS does not support the Table Design tool for any SKU of SQL Server) and is unrelated to the massively incorrect and useless context menu in SSMS for Temporal Tables in SQL Server Express. – Dai Apr 9 at 11:05

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.