Skip to Main Content
Microsoft® SQL Server® 2008 Administrator's Pocket Consultant, 2nd Edition
book

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

by William R. Stanek
April 2010
Intermediate to advanced content levelIntermediate to advanced
738 pages
22h 18m
English
Microsoft Press
Content preview from Microsoft® SQL Server® 2008 Administrator's Pocket Consultant, 2nd Edition

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

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.

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

Microsoft® SQL Server® 2008 Administrator's Pocket Consultant

Microsoft® SQL Server® 2008 Administrator's Pocket Consultant

William R. Stanek

Publisher Resources

ISBN: 9780735645158Errata