To logically group tables, proc, views together, all employee related objects in the employee schema etc.,
possibility to assign permissions to a schema makes it worth it from an administration perspective.
create schemas like landing, staging depending on the specific domain
like CDC schema, it will NOT be confusing with real table names
similar to c# namespaces
in 2k, if joe created jobs it will be called as joe.jobs
what if joeleaves company?
then you will have to change the ownership from joeto dbo.jobs
huge administrative effort……so please be mindful
0 Comments.