Click here to monitor SSC
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
deepmustang 90114
deepmustang 90114
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 156
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
Sean Lange
Sean Lange
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16632 Visits: 17024
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)
deepmustang 90114
deepmustang 90114
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 156
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
Sean Lange
Sean Lange
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16632 Visits: 17024
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
Understanding and Using APPLY (Part 1)
Understanding and Using APPLY (Part 2)
SQLTreeo
SQLTreeo
Grasshopper
Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)Grasshopper (15 reputation)

Group: General Forum Members
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
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search