O'Reilly logo

Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant by William R. Stanek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 9. Manipulating Schemas, Tables, Indexes, and Views

SQL Server 2005 introduces a new model for managing the fundamental units of data within databases. All data within 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. So there are three basic levels of scoping and ownership:

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

  • Schema. Includes all objects defined within ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required