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,360
  • 12
  • 32
  • 61
  • I've always found it odd that duplicates can have wildly different question titles. There is a definite different between 'avoiding the dbo schema' and 'using multiple schemas in a database (including dbo)' – Zach Smith Aug 08 '18 at 09:58

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.

Bill Hughes
  • 95
  • 9
  • Your answer is best suited as comment, I am sure you would agree the real answer to question would include lot of pros and cons. – Shanky Aug 06 '18 at 15:11
  • thanks - i agree with using it to identify data that comes from 3rd party sources. other than that, here is a good explanation – Zach Smith Aug 08 '18 at 09:55