Microsoft® SQL Server® 2008 Administrator's Pocket Consultant, 2nd Edition

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

• Working with Schemas

• Getting Started with Tables

• Table Essentials

• Working with Tables

• Managing Table Values

• Using Views

• Creating and Managing Indexes

• Column Constraints and Rules

• Creating Partitioned Tables and Indexes

• Compressing Tables, Indexes, and Partitions

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.