90
Part I: Laying the Foundations
Navigating the Tree
In keeping with the Explorer metaphor, Object Explorer (see Figure 5-5) is a hierarchical,
expandable view of the objects available within the connected servers.Each Database Engine server node includes Databases, Security, Server Objects, Replication,
AlwaysOn High Availability, Management, Integration Services Catalogs, and SQL Server
Agent. Most of the tree structure is fi xed, but additional nodes are added as objects are cre-
ated within the server.FIGURE 5-5
Object Explorer’s tree structure invites you to explore the various components of SQL Server
management and development.The Databases node contains all the server’s databases. When you right-click on a database,
the context menu includes a host of options and commands. Under each database are stan-
dard nodes (see Figure 5-5), which manage the following database objects:■ (^) Database Diagrams: Illustrates several tables and their relationships. A database
may contain multiple diagrams, and each diagram does not need to display all the
tables. This makes it easy to organize large databases into modular diagrams.
c05 July 23, 2012 11:44 AM V1
c05.indd 90c05.indd 90 7/30/2012 4:14:45 PM7/30/2012 4:14:45 PM
http://www.it-ebooks.info