为什么我的新架构没有显示在表属性窗格中? [英] Why is my new schema not showing in the table properites pane?

问题描述

我使用的是 SQL Server 2008 Express 和 Sql Server Management Studio 2008.

I am using SQL Server 2008 Express and Sql Server Management Studio 2008.

我正在尝试将数据库表与新架构相关联.

I am trying to associate a database table with a new schema.

我通过导航到对象资源管理器中的安全->架构创建了一个新架构.我右键单击该文件夹并创建了一个名为People"的新架构，并将所有者设置为 db_owner.这个新架构现在出现在对象资源管理器中.

I have created a new Schema by navigating to Security->Schemas in object explorer. I right clicked on the folder and created a new schema called 'People' and set the owner as db_owner. This new Schema now appears in object explorer.

我现在想将一个表与此架构相关联.我在设计视图中打开表，然后单击包含可用架构的表属性窗格中的下拉列表，但我新创建的架构不可见.

I would now like to associate a table with this schema. I open the table in design view and click on the drop down list in the table Properties pane which contains the available schemas but my newly created schema is not visible.

我尝试刷新对象浏览器中的所有内容.关闭设计视图并重新打开等，但它仍然不存在.

I have tried refreshing everything throughout object explorer. Closing design view and reopening etc. but still it isn't there.

我做错了什么吗?

有人能指出我正确的方向吗?

Can anyone point me in the right direction please?

推荐答案

以最荒谬的方式排序.

显然在每个层级都刷新对象浏览器是不够的.

Apparently refreshing object browser at every hierarchical level is not sufficient.

我不得不关闭sql管理工作室，然后重新打开它.架构列表随后设法刷新，并允许我将我的新自定义架构与表相关联.

I had to CLOSE sql management studio, then re-open it. The list of schemas had then managed to refresh and would allow me to associate my new custom schema with the table.

IMO 这是垃圾.

这篇关于为什么我的新架构没有显示在表属性窗格中?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！