Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Custom subfolders in Object Explorer?

Status
Not open for further replies.

sschrupp

Programmer
Feb 23, 2007
25
US
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.

 
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
 
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.
 
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!
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top