SSMS 2008 - Is there a way to better display tables in various schemas

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » SSMS 2008 - Is there a way to better display...

SSMS 2008 - Is there a way to better display tables in various schemas

Rate Topic

Display Mode

Topic Options

Author

Message

deepmustang 90114

Posted Friday, April 08, 2011 12:46 PM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 12:46 PM
Points: 14, Visits: 131

In sql server 2008 we have 30 users schemas setup under a singel database (say "UserDB")
Each user is set up with access to his/her own schema
So when you login to server and drill down to Databases >>UserDb >> Tables, you will see the tables that belong to your schema

Now I have to give cross Schema access. User 1 wants to see User 2's schema tables.
User 1 tables shows up as user1.table1 and user 2 tables show up as user2.table2
In SQL server 2008 we have 30 users schemas setup under a single database (say "UserDB")
Each user is set up with access to his/her own schema
So when you login to server and drill down to Databases >>UserDb >> Tables, you will see the tables that belong to your schema

Now I have to give cross Schema access. User 1 wants to see User 2's schema tables.
User 1 tables shows up as user1.table1 and user 2 tables show up as user2.table2

Question is: Instead of listing ALL the tables, differentiated by prefix, is there a way to show them like windows folders.
Example:
Parent folder (Tables)
- Child Folder 1 (User1 Schema)
- Child Folder 2 (User2 schema)

This is purely to group the tables for better visual representation (and no technical reason behind it)
OR
Is there a better way to visually show tables from multiple schemas under the same database ?

Thanks

Post #1090858

Sean Lange

Posted Friday, April 08, 2011 1:39 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 3:32 PM
Points: 8,980, Visits: 8,540

Are you asking how to get a list of them or how best to display it in your application? If it is the first, you already have that knowledge from the listing by user. If it is the second, that is a UI decision that would be based on the type of application, who the consumers are, what language it is written in etc...

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Post #1090891

deepmustang 90114

Posted Friday, April 08, 2011 3:10 PM

Grasshopper

Group: General Forum Members
Last Login: Wednesday, February 13, 2013 12:46 PM
Points: 14, Visits: 131

My question was how do you display (group) the Schema tables with a treeview kind of look in the SSMS 2008 (not any custom application). Also I am not trying to script them.

See the link below.

https://connect.microsoft.com/SQLServer/feedback/details/580903/add-ability-to-add-folders-groups-to-logically-sort-tables-in-ssms

Thanks

Post #1090959

Sean Lange

Posted Friday, April 08, 2011 3:19 PM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 3:32 PM
Points: 8,980, Visits: 8,540

Now I see what you are asking. I don't know of any way to list tables like that but it does seem like it could be a good thing in some situations. Base level would be the schemas and then you could drill down into the objects for each schema. I don't have enough schemas in any of our systems that would be useful for me but I can see where it would be. Maybe somebody will come back with an answer. sorry I can't be any more help. Hehe

_______________________________________________________________

Need help? Help us help you.

Read the article at http://www.sqlservercentral.com/articles/Best+Practices/61537/ for best practices on asking questions.

Need to split a string? Try Jeff Moden's splitter.

Cross Tabs and Pivots, Part 1 – Converting Rows to Columns
Cross Tabs and Pivots, Part 2 - Dynamic Cross Tabs

Post #1090965

SQLTreeo

Posted Monday, September 24, 2012 12:57 AM

Grasshopper

Group: General Forum Members
Last Login: Friday, January 18, 2013 1:14 AM
Points: 15, Visits: 92

Or try SSMS add-in SQLTreeo. It enables you to organize tables, databases or stored procedures in your custom folders.

__________________________________________________________________________________________
SQLTreeo.com - My Blog and Free SSMS Productivity Add-In

Post #1363347

« Prev Topic | Next Topic »

Permissions