SSMS Object Explorer - Select Top N Rows missing when connected to Azure DB

Question

I just upgraded my SSMS to 2008 R2. I'm missing the option to select the top 1000 rows from a table, like this:

Mine looks like this:

I know how to change the number of rows that are displayed, but the options aren't there at all. I saw that someone submitted a bug for this a few years ago, but there was no workaround, and I'm not sure what to do. Any ideas?

EDIT - Azure Problem?

I just used SSMS to open my local SQL Server, and I get the option to select the top 100 rows. But in my other SSMS instance, the one that is connected to my Azure DB, I don't see it. Is it possibly an Azure limitation?

Answer 1

You can try this command from your SSMS:

select top 100 * from SalesLT.Customer

My SSMS is linked to AzureDB.  So there is no Azure limitation as such.