Is there a need of namespaces in database?
database-design, namespaces
Solution
If you are using SQL 2000, you are stuck with either using database owners as namespaces, which is painful because it requires you to contrive users just for their namespaces.
In SQL 2005, you can create schemas, which are essentially name spaces.
In all SQL databases you can use prefixes, e.g. hr_ for human resources, sys_ for system related, etc.
Problem
Often I am frustrated by the fact that there are a lot of tables, views, stored procedure all placed under one hierarchy. I am looking for a way (like namespaces) that would group related tables under one banner. This would not only be easy to understand. Also i would avoid the need for coming up with fancy names. I am not aware of any present trick to achieve this, Kindly help me if there is way I can use to achieve the similar effect. Thanks