Table Chaos

Please support our MS SQL advertiser: Intel Parallel Studio Home
Reply

Join Date: Jun 2009
Posts: 2
Reputation: roschc is an unknown quantity at this point 
Solved Threads: 0
roschc roschc is offline Offline
Newbie Poster

Table Chaos

 
0
  #1
Jun 30th, 2009
HI, I have in my database 50+ tables and getting slowly lost because it's looks like a bit messy up because of the long list in the Object Explorer (SQL Server Management Studio).

Does anybody know a way how to organize this tables in subfolders like how the "system tables" are in an extra subfolder ("system tables")?
Reply With Quote Quick reply to this message  
Join Date: Feb 2009
Posts: 3,187
Reputation: sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of 
Solved Threads: 571
Sponsor
sknake's Avatar
sknake sknake is offline Offline
.NET Enthusiast

Re: Table Chaos

 
0
  #2
Jun 30th, 2009
You can't. Use a naming convention such as "Cust*" for all the custom tables, "Inv*" for invoice tables. It will group them by name but that is about as good as it gets.
Last edited by sknake; Jun 30th, 2009 at 8:36 am.
Scott Knake
Custom Software Development
Apex Software, Inc.
Reply With Quote Quick reply to this message  
Join Date: Jun 2009
Posts: 2
Reputation: roschc is an unknown quantity at this point 
Solved Threads: 0
roschc roschc is offline Offline
Newbie Poster

Re: Table Chaos

 
0
  #3
Jun 30th, 2009
Thank you for your answer. It's a pity...

Because the front end are a web application it's too later now to change the table names.

Does the MS SQL Server 2008 have this function or still not possbile (i use the MS SQL Server 2005).
Reply With Quote Quick reply to this message  
Join Date: Feb 2009
Posts: 3,187
Reputation: sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of sknake has much to be proud of 
Solved Threads: 571
Sponsor
sknake's Avatar
sknake sknake is offline Offline
.NET Enthusiast

Re: Table Chaos

 
0
  #4
Jun 30th, 2009
As far as I know it does not and I have never heard this request before. I think it is fine the way it is personally.
Scott Knake
Custom Software Development
Apex Software, Inc.
Reply With Quote Quick reply to this message  
Join Date: Dec 2008
Posts: 22
Reputation: NextCom is an unknown quantity at this point 
Solved Threads: 0
NextCom NextCom is offline Offline
Newbie Poster

Re: Table Chaos

 
0
  #5
Jun 30th, 2009
Sorry but i don't think it's possible in SQL 2008 either, I don’t even think it have been discussed. Most database designers use table names to categorise, and if they don’t then they change to categorised table names later. By using the same table name structure as sknake mentioned.
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:


Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC