The SMO Object Model

A high-level fragment of the SMO Object Model diagram is shown in Figure 11-1.

As you notice in the picture, some of the names are plural. These plural names represent collections of objects. For example, the top level Server object has a collection of Databases holding actual Database instance objects present in the given Database Engine instance. Subsequently each database has a collection of Table objects and so on. If you can imagine this diagram extended to cover nearly every object inside SQL Server 2005, you will have an idea how large this object model is. Just to give you some idea, SMO has over 150 instance classes.