Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

When I was exploring the master database in SSMS I noticed that under the Tables folder there is another folder called Systems Tables that houses a bunch of tables. Is it possible for us to create a structure akin to Systems Tables within our database?

I am looking to organize tables and stored procedures into project specific folders. Under the new setup - when I am referring to my table object I would have to use the following syntax (I am guessing here):

[dbName].[projectName].[dbo].[tableName] 

Also, apart from clearing up the clutter, do anybody foresee any performance improvement/degradation because of this re-organization? I use Microsoft SQL Server 2008 R2.

share|improve this question

2 Answers 2

up vote 8 down vote accepted

There is no way to create custom folders directly in SQL Server Management Studio.

Here are a few common strategies:

  1. Group database objects by schema to help one-dimensional organization
  2. Name objects from broad to specific areas

For the 1st option:

billing.Product
billing.Receipt
internal.Employee
internal.Office

Schemas are most primarily used to logical grouping of database objects, and can also provide an extra layer of security when using more than just the out-of-the-box configuration. And the secondary benefit is, of course, the grouping of these items within SSMS Object Explorer.

For the 2nd route (name objects from broad to specific), it'd be something like this:

dbo.Animal
dbo.AnimalDiet
dbo.AnimalDietFootType
dbo.AnimalHabitat
dbo.Person
dbo.PersonAddress
dbo.PersonAutomobile
dbo.PersonAutomobileArchive

So on an so forth. You can see that these objects alphabetically order themselves. It's not just good for visual organization, but a great naming convention in my opinion.

share|improve this answer

This functionality isn't provided by Management Studio.

However, there are 3rd party add-ins that offer this feature, e.g. SQLtreeo and SQL Handy Groupie. I'm not affiliated with either of these companies, nor can I vouch for the reliability / stability of their add-ins or whether or not they will meet all of your requirements.

share|improve this answer

protected by Mark Storey-Smith Nov 27 '13 at 0:12

Thank you for your interest in this question. Because it has attracted low-quality answers, posting an answer now requires 10 reputation on this site.

Would you like to answer one of these unanswered questions instead?

Not the answer you're looking for? Browse other questions tagged or ask your own question.