Design in Query Editor disabled for Azure databases

Question

When I try to manage an Azure Database query in SQL Managements Studio 2012 I see that the "Design in Query Editor" option is disabled. It is enabled for other databases but not for Azure. Is there a way to enable it?

Thanks

Answer 1

Unfortunately, this is a by design issue. Not all SSMS functionality from on-premise SQL Server is supported when connected to Azure SQL database, "Design Query in Edit" greys out because it's not supported for azure sql database. For more information, please refer to this thread: https://social.msdn.microsoft.com/Forums/sqlserver/en-US/22d29cb7-48d1-4cbd-af2e-30b66ebdc7d4/ssmss-design-query-in-editor-greyed-out?forum=sqltools

Answer 2

As @forester123 mentioned this is not supported for Azure databases. But there's a workaround!

In object explorer, collapse the database you want and right click "Views" and click "New View...". Here you can have access to a query designer view. As long as you do not save it, then it works as a query designer.