Can't edit rows of Azure database in SQL Server Management Studio

Question

I can't edit or view rows in an Azure database using SQL Server Management Studio. Am I missing something obvious? The option is not there.

Answer 1

You can now, you need to have SSMS 2014 with Cummulative Update 5 or later. The latest CU is always listed on the "SQL Server 2014 build versions" KB article.

Answer 2

If you are referring to the items Select Top 1000 Rows and Edit Top 200 Rows in the contextual menu of a table, they are not available on Microsoft Azure Databases. You should use SQL statements to retrieve/modify your data.

Update: as of 18-Dec-2014 you can do this with the latest SSMS: http://blogs.msdn.com/b/sqlreleaseservices/archive/2014/12/18/sql-server-2014-management-studio-updated-support-for-the-latest-azure-sql-database-update-v12-preview.aspx