Chapter 8. Manipulating Schemas, Tables, and Views

Objects are the fundamental units of data storage in databases. All data in a database is contained within a Database object. Each Database object contains Schema objects, and those Schema objects contain the tables, indexes, views, and other objects that make up the database. The three basic levels of scoping and ownership are as follows:

  • Database. Includes all objects defined within a database. This level is owned by a specific user.

  • Schema. Includes all objects defined within a schema. This level is owned by a database-level security principal.

  • Schema-contained object. Refers to any ...

Get Microsoft® SQL Server® 2012: Pocket Consultant now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.