Azure托管实例的表设计中的架构下拉列表 [英] Schema drop down in table design for Azure Managed Instance

问题描述

您好，

我正在开发Azure托管实例。 我在表的设计视图中，并尝试从表属性的下拉列表中选择一个已创建的模式，但未列出。 架构将dbo作为架构所有者。 我做了
注意，如果架构所有者不是dbo，那么架构会出现。 在SQL Server 2017中，即使所有者是dbo，也会在下拉列表中列出架构。 这是Azure托管实例中的新功能吗？

谢谢，

Sylvia

解决方案

你好，

为了获得Azure Managed实例的最佳用户体验，请下载并安装SSMS v18.0。虽然仍处于测试阶段，但它包含许多Azure托管实例的修复程序。

https://docs.microsoft.com/ en-us / sql / ssms / download -sql-server-management-studio - ssms？view = sql-server-2017

希望这会有所帮助。

问候，

Alberto Morillo

SQLCoffee.com

Hello,

I am working on an Azure Managed Instance.  I am in the design view of a table and trying to select one of my already created schemas from the drop down in table properties but it is not listed.  The schema has dbo as schema owner.  I did notice that the schema will show up if the schema owner is something other than dbo.  In SQL Server 2017 on prem the schema is listed in the drop down even if the owner is dbo.  Is this something new in Azure Managed Instance?

Thank you,

Sylvia

解决方案

Hello,

For the best user experience with Azure Managed instance please download and install SSMS v18.0. Although is still in beta, it contains many fixes for Azure Managed instance.

https://docs.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms?view=sql-server-2017

Hope this helps.

Regards,

Alberto Morillo
SQLCoffee.com

这篇关于Azure托管实例的表设计中的架构下拉列表的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！