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. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

My database contains more than 200 tables. When I want to modify or insert a table, I find it difficult to find it among all those tables.

  • Is there any way to collect related tables in a folder structure inside my DB? I'd have groups of folders, each one containing tables for a certain part of my application.
  • If that's not possible, how can I manage all these tables and make it easy for myself?
share|improve this question
up vote 8 down vote accepted

is there any way to collect tables related to certain part in a folder inside my DB?? i have group of folders each one contain tables of certain part of my application

The direct answer to that within SSMS would be no.

However, there are two ways you can go about this:

  1. Use schemas to contain logically connected and functional objects

  2. Use a BroadToSpecific naming convention to alphabetically group objects (I.e. Person, PersonAddress, PersonAddressArchive, etc. These will appear alphabetically grouped)

share|improve this answer
+1 Schemas are excellent for separating concepts but they don't give you much "window dressing" for organizing your work in SSMS – Matthew Nov 6 '13 at 18:46

yes there is one option:

other could be:

share|improve this answer
+1 I recently started using SQLTreeo and I think it adds a lot of value when you have larger databases, especially with multiple scehams... I think the current asking price is a bit high, though. – Matthew Nov 6 '13 at 18:47

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

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