Custom subfolders in Object Explorer?

[sschrupp]

Hi, is there a way to create folders in the "Tables" or "Stored Procedures" groupings? We're going to have a number of tables and procedures and it'll start to get very confusing if it's all just one big long list.

Even if we do something like MainProcess.MainCategory_SubCategory_SubSubCategory_Function to alphabetize things it will be a confusing mess.

 

[SQLBill]

Nope. When you run the command CREATE TABLE it puts the table in the Tables folder. Same with stored procedures, functions and everything else. You can't create subfolders.

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[RiverGuy]

There are "filter settings" in the context menu of the folders within SSMS which may prove useful. For example, if your application uses it's own schema other than dbo, you can filter on your custom schema name.

 

[djj55]

You can also set it up to sort by schema, so maybe create tables within schemas for the sort.

djj
The Lord is My Shepard (Psalm 23) - I need someone to lead me!

 

[sschrupp]

RiverGuy, thanks for the filtering tip. I think that'll help the guys a bit as we start getting more in our list.

That should work pretty good as long as we do a decent job with our naming convention.

 

[markros]

It is a really good suggestion and should be listed on MS Connect website.

PluralSight Learning Library

 

[markros]

You can vote this suggestion

https://connect.microsoft.com/SQLSe...lders-groups-to-logically-sort-tables-in-ssms

PluralSight Learning Library