Ad:

MS SQL Discussion Thread
Unsolved
Views: 620

Jun 30th, 2009

Table Chaos

Expand Post »

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

Similar Threads

Need help with HTMl Table echoing? in PHP
Table Adapters in Visual Basic 4 / 5 / 6
How can i deledet and update from table ??????? in PHP
Copying table from one mdb to another in ASP
Table of Contents Script in Java

roschc

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Jun 2009

Permalink

Jun 30th, 2009

Re: Table Chaos

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.

sknake

Featured Poster

Reputation Points: 1749

Solved Threads: 735

Senior Poster

Offline

3,948 posts
since Feb 2009

Permalink

Jun 30th, 2009

Re: Table Chaos

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).

roschc

Reputation Points: 10

Solved Threads: 0

Newbie Poster

Offline

2 posts
since Jun 2009

Permalink

Jun 30th, 2009

Re: Table Chaos

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.

sknake

Featured Poster

Reputation Points: 1749

Solved Threads: 735

Senior Poster

Offline

3,948 posts
since Feb 2009

Permalink

Jun 30th, 2009

Re: Table Chaos

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.

NextCom

Reputation Points: 18

Solved Threads: 0

Light Poster

Offline

26 posts
since Dec 2008

This thread is more than three months old

No one has posted to this discussion for at least three months. Please let old threads die and do not reply to them unless you feel you have something new and valuable to contribute that absolutely must be added to make the discussion complete. Otherwise, please start a new thread in this forum instead.

Previous Thread in MS SQL Forum Timeline: Help required for UPDATE TRIGGER

Next Thread in MS SQL Forum Timeline: querry problem

DaniWeb Message

Cancel Changes

User Name
Password