Chapter 9. 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

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 ...

Get Microsoft® SQL Server™ 2005 Administrator's Pocket Consultant now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial