在SSMS中按架构对表进行分组 [英] Group tables by schema in SSMS

问题描述

在Visual Studio的服务器资源管理器"窗口中，有一个非常好的功能，可让您查看按架构分组的数据库对象:

In Visual Studio's Server Explorer window there's a very nice feature that lets you see the DB objects grouped by schema:

它变成了这个对象树:

数据连接-> MyServer ->表-> MyTable ( MySchema )

Data Connections -> MyServer -> Tables -> MyTable (MySchema)

进入这一个:

数据连接-> MyServer ->架构-> MySchema -> MyTable

Data Connections -> MyServer -> Schemas -> MySchema -> MyTable

我一直在寻找SSMS中的特定功能，但是找不到它.

I've been looking for this particular feature in SSMS but was unable to find it.

• 它存在吗?
• 如果没有，是否有可以提供此功能的插件?
• 或者也许有一个插件可以帮助简化具有很多个对象的数据库中的导航?

• Does it exist?
• If not, is there a plugin which would provide this feature?
• Or perhaps is there a plugin which would help ease navigation in DBs which have lots of objects?

请注意，我知道SSMS对象过滤器.它总比没有好，但还不足够，因为我经常一次从多个模式访问对象.

Please note I'm aware of SSMS object filters. It's better than nothing but not sufficient, as I'm often accessing objects from multiple schemas at once.

推荐答案

如果您要使用免费工具，请 SSMS架构文件夹( GitHub存储库)是您的解决方案.它做得很好.

If you want a free tool, SSMS Schema Folders (GitHub repo) is your solution. It does the job beautifully.

这篇关于在SSMS中按架构对表进行分组的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！