SQL Server Management Studio 架构视图
我正在使用 SQL 服务器和几个数据库。每个数据库可能有许多模式，例如 dbo.、admin.、other.，我已经厌倦了滚动试图查找内容。
如果我正在处理特定于架构的项目，我想从我的视图中过滤掉除该架构之外的所有其他内容。作为 dbo，我看到了一切，这意味着我一天的大部分时间都在骚扰我的滚轮（这是一个笑话）。
这在 SQL Server Management Studio 2008 中可能吗？
I'm working with a SQL server and several databases. Each database may have many schema's, such as dbo., admin., other., and I'm getting tired of scrolling around trying to find things.
If I'm working on a schema specific project, I want to filter out everything else from my view except that schema. As dbo, I see everything which means I spend the majority of my day molesting my scroll wheel (that is a joke).
Is this possible in SQL Server Management Studio 2008?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（3）
在 SSMS 2005 或 2008 中，右键单击标题：“存储过程”、“表”等，然后单击“筛选器设置”，然后将“架构”的“运算符”更改为“不包含”或“包含”等等，然后设置一个值来过滤它们......
In SSMS 2005 or 2008, right click on the heading: "Stored Procedures", "Tables", etc, then on "Filter Settings", then for the "Schema" change "Operator" to "Does not contain" or "Contains", etc and then set a Value to filter them...
是：不要以 db_owner 或“sa”身份连接。
以只能访问和更改所需架构的用户身份进行连接。
这样，引擎“元数据可见性”将自动执行此操作
Yes: don't connect as db_owner or "sa".
Connect as a user that can access and change the desired schema only.
This way, the engine "Metadata visibility" will do it automatically
仅供参考，我正在 cdc 模式（创建的变更数据捕获模式）下搜索表。经过一番努力，我发现这些表位于 Tables->System Tables 文件夹中。因此 SSMS 确实显示了非默认架构，但在本例中它位于不同的文件夹中。
FYI, I was searching for tables under cdc schema, the change data capture schema that was created. After much struggle, I found that those tables are in the Tables->System Tables folder. So SSMS did show the non default schema but in this case it was in a different folder.