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.

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
    
what kind of database system? –  Max Vernon Nov 22 '12 at 4:08
1  
"My SQL database" - do you mean "MySQL database" or "My SQL Server database"? "SQL" is a language, not an RDBMS. –  Thomas Stringer Nov 22 '12 at 15:10

2 Answers 2

up vote 6 down vote accepted

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

If you're asking about SQL Server, then 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: http://www.sqltreeo.com/wp/

other could be: http://www.skilledsoftware.com/

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

 
discard

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.