查询编辑器中的设计已针对Azure数据库禁用 [英] Design in Query Editor disabled for Azure databases

问题描述

当我尝试在SQL Managements Studio 2012中管理Azure数据库查询时，我看到查询编辑器中的设计"选项被禁用.已为其他数据库启用了此功能，但未为Azure启用了此功能.有办法启用它吗?

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?

谢谢

推荐答案

不幸的是，这是一个设计问题.当连接到Azure SQL数据库时，并非支持本地SQL Server的所有SSMS功能，因为蓝色的sql"数据库不支持编辑中的设计查询"，因此显示为灰色.有关更多信息，请参考以下线程: https://social.msdn.microsoft.com/Forums/sqlserver/zh-CN/22d29cb7-48d1-4cbd-af2e-30b66ebdc7d4/ssmsss -design-query-in-editor-greyed-out?forum = sqltools

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

这篇关于查询编辑器中的设计已针对Azure数据库禁用的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！