Hello everyone, How do I group a set of tables or label them together?
In our project,each user has two separate tables allocated for them. I need to group all users tables separately.
How do I accomplish this?
Thanks.
A:
You may have to create another table to track what tables are allocated to whom. You can save Object Id of the tables with the User's ID.
TheVillageIdiot
2009-07-24 06:49:14
I already have that. My problem now is that it's all displayed totally mixed up with the other core tables in Management Studio.
Josh
2009-07-24 06:50:50
+2
A:
Perhaps you could use SQL Server Schemas to create logical separation of database objects (tables,views,stored procedures,functions,triggers etc.).
See the Microsoft Books Online Reference: User-Schema Separation
Using this method, you could then group related tables into the same schema.
John Sansom
2009-07-24 08:02:09
@Tom H: Dude come on why are modifying my post spelling from British to American English :-)
John Sansom
2010-07-06 15:36:55
Hey, I stopped changing "optimise" and "colour", I didn't realize that "seperate" was a British spelling. I thought it was just a common misspelling. :)A quick search turned this up from those blokes over at Oxford: http://www.oxforddictionaries.com/page/spellingcommonmisp/common-misspellings;jsessionid=D38660456AB0B89CFB410B03FC50E8CB
Tom H.
2010-07-06 16:18:04