Tell me more ×
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.
up vote 3 down vote favorite

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
"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

up vote 5 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
up vote 1 down vote

yes there is one option: http://www.sqltreeo.com/wp/

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

share|improve this answer

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.