If I have a database MyDB, is it considered good practice / bad practice to use schemas other than dbo?
For example:
MyDB.reports.YearlySales
MyDB.reports.TopSellers
MyDB.[data].ProviderX
MyDB.[data].ProviderY
etc
If I have a database MyDB, is it considered good practice / bad practice to use schemas other than dbo?
For example:
MyDB.reports.YearlySales
MyDB.reports.TopSellers
MyDB.[data].ProviderX
MyDB.[data].ProviderY
etc
In my opinion there is nothing wrong with it. In my data warehouse I use different schemas to differentiate between data for departments or in the case that I am copying tables from a third party database, to show where those tables come from.