I am thinking, if there is the functionality that can hierachically group the tables, views, and stored procedures into different sections within each database, it will be much clearer and logical for maintain the database objects.
For example, to create containers in the console tree of Management Studio or Enterprise Manager, or even apply the namespace/subnamespace features to the tables/views/stored procedures of each database.
A clearer explanation:
Inside each database, all the tables, stored procedure and views are at the same level, if new folders/containers can be created to segmen all these database objects into different groups, it will be much more clear.
An even advanced feature is to apply namespace concept to the database objects, so that it will truly hierachical besides the appearnce in the console tree.
|||This probably isn't exactly what you're looking for, but ...
You can use SCHEMAs to put tables, procedures, types, etc. into separate namespaces.
From SSMS, you can
Create a new schema from the "Database/Security/Schemas" node in Object Explorer|||
This functionality does not currently exist. You can submit this suggestion through https://connect.microsoft.com/SQLServer.
Cheers,
Dan
没有评论:
发表评论