4.1. Use SQL Server Schemas

SQL Server supports many different kinds of objects, such as tables, views, stored procedures, and functions. One of the most important tasks that an administrator does is to manage and secure these objects. These objects are the building blocks of a server-side database application. To simplify the process management and securing them, SQL Server 2008 allows you to organize objects into schemas.

4.1.1. Understand Schemas

A schema is a logical container for SQL objects. When you create objects in Microsoft SQL Server, you can organize them into schema containers. In SQL Server 2008, you can use schemas for the following:

  • Name resolution

  • Object organization

  • Security management

For example, assume you were working with ...

Get SQL Server® 2008 Administration: Instant Reference 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