0

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
Zach Smith
  • 2,430
  • 13
  • 34
  • 65

1 Answers1

1

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.