Schema - Do you avoid using user-schema separation?
3/01/2020 4:21 PM by
User-schema separation allows more flexibility by adding another level of naming and shifting ownership of database objects to the schema, not the user. So, is it worth doing? Unless you are working with a very large database (100+ tables), the answer is "no". Most smaller databases have all objects with owner "dbo", which is fine in most cases.
- Figure: Bad Example - AdventureWorks using user schema - instead, keep it simple and avoid using user schema unnecessarily
- Figure: Good Example - Adventure works with user schema cleaned out. Much simpler and more readable
Do you feel this rule needs an update?