Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Schema question

Author  Topic 

michael.appleton
Posting Yak Master

160 Posts

Posted - 2009-09-18 : 11:04:04
Hello,
Can anybody tell me when I should be splitting a objects in a database out into different schema? At the moment the whole database is the default "dbo" schema.

I have seen examples of splitting databases up into "Sales" and perhaps "HR" schemas, but I'm not really sure what the point of it is. I'm guessing it's a way of managing security by grouping objects together, but am I missing something?

Thanks for the help,

Mike
   

- Advertisement -