From the course: SQL Server 2014: Developing Databases

Unlock the full course today

Join today to access over 22,400 courses taught by industry experts or purchase this course individually.

Utilizing schemas with tables

Utilizing schemas with tables - SQL Server Tutorial

From the course: SQL Server 2014: Developing Databases

Start my 1-month free trial

Utilizing schemas with tables

- OK, in order to demonstrate the concept of schemas I just did a new query and I typed in this code that you see right here. OK, now we're going to talk about the concept of using a schema to define areas of responsibility. Schemas were introduced with SQL 2005. The idea of a schema is to separate out the ownership from the usage, that is, the objects within a schema can be assigned to a certain owner or to a certain group, allowing that group to be responsible for changes within the tables or the objects that are contained within that schema. The then users of the database are completely separated out. This arose from problems we had in the past with orphaned objects, but be that as it may. Let me show you use of schemas. So we look at AdventureWorks2014 and we expand out the table. You see as we drop down, there is our default schema, DBO, database owner, but now immediately as we move down to where the actual data is, we have the HumanResources, and they have within HumanResources…

Contents