Schemas are a very useful tool for managing the objects in your database. From security to process to placement, schemas provide you with another tool to control how your database behaves.
SchemasThe tables created so far in this blog series have all been attached to a schema: dbo. Depending on how you log into the server and the security settings for your user, this is usually the default schema. A schema is simply a container in which you place objects. Once placed there, a schema is a method for managing the objects it contains. Schemas give you a simple way to control placement of the objects on filegroups. Schemas are a very easy way to manage security. The use of schemas becomes extremely important as your database becomes more and more complex. Any database you create following this blog series will be fairly simple in order to focus on concepts related to the fundamentals scope of the series. For this blog, I won't spend lots of time dealing with complex business models. However, because you will have to deal with complex business models, it's best to have an understanding of the tools you have to help deal with them.
No comments:
Post a Comment