Microsoft® SQL Server® 2008 Administrator's Pocket Consultant

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

In this chapter:

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 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. The three basic levels of scoping and ownership are as follows:

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