Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
drPascal
Starting Member
5 Posts |
 Posted - 2007-09-14 : 20:15:55
|
| Hi, is there a way to group hundreds of tables into folders or any type of table grouping in 2005? |
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-14 : 20:47:01
|
Not sure what you mean by that, for what purpose?
Future guru in the making. |
 |
|
|
drPascal
Starting Member
5 Posts |
Posted - 2007-09-14 : 21:26:06
|
| I guess what I'm asking is how do I organize many many tables so that you don't have to go looking for a "needle in a haystack" when looking for a table? Or is there a much better approach that I'm missing? |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-14 : 21:56:02
|
quote:
Originally posted by drPascal
I guess what I'm asking is how do I organize many many tables so that you don't have to go looking for a "needle in a haystack" when looking for a table? Or is there a much better approach that I'm missing?
You can group the tables based on relationships and the logical groupings in your diagrams, couple that with a data dictionary and you should be set.
Future guru in the making. |
|
|
|
drPascal
Starting Member
5 Posts |
Posted - 2007-09-14 : 21:59:26
|
| Thanks for such a fast response! |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-15 : 00:40:26
|
quote:
Originally posted by drPascal
Thanks for such a fast response!
No problem, here is a good article on the subject:http://www.devx.com/dbzone/Article/31733
Future guru in the making. |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-09-15 : 11:03:11
|
| in sql server schemas are used for exactly this.they group logicaly close objects.if you're familiar with .net schemas are in a way analogous to namespaces_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
|
|
|
Zoroaster
Aged Yak Warrior
702 Posts |
Posted - 2007-09-16 : 01:12:35
|
quote:
Originally posted by spirit1
in sql server schemas are used for exactly this.they group logicaly close objects.if you're familiar with .net schemas are in a way analogous to namespaces_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp
Yes, like Oracle schemas. That was only introduced in SQL Server 2005 right?
Future guru in the making. |
|
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2007-09-16 : 02:03:49
|
quote:
Originally posted by Zoroaster
Yes, like Oracle schemas. That was only introduced in SQL Server 2005 right?
correct, schemas proper came in 2005.
elsasoft.org |
|
|
|
|
|
|
Table Folders or Table Clustering