-->

Design in Query Editor disabled for Azure database

2020-04-07 04:48发布

问题:

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

回答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