Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SSMS 2008 - Is there a way to better display tables in various schemas Expand / Collapse
Author
Message
Posted Friday, April 8, 2011 12:46 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Friday, April 8, 2011 1:39 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:14 PM
Points: 13,126, Visits: 11,964
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
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1090891
Posted Friday, April 8, 2011 3:10 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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
Posted Friday, April 8, 2011 3:19 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 4:14 PM
Points: 13,126, Visits: 11,964
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.

_______________________________________________________________

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
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
Post #1090965
Posted Monday, September 24, 2012 12:57 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Friday, September 13, 2013 3:22 AM
Points: 15, Visits: 94
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 »

Add to briefcase

Permissions Expand / Collapse