Programming SQL Server 2005

Chapter 10. SQL Server Management Objects (SMO) Instance Classes, Part 1

SMO instance classes form a hierarchy matching the database server hierarchy. The top SMO objects are SQL Server instances represented by the Server object, under which is a hierarchy of instance objects that includes databases, tables, columns, indexes, and stored procedures.

This chapter provides an overview of the SMO instance classes for administering database objects that are used to store data. Following this overview, the chapter shows how to use these classes programmatically, how to subscribe to SMO events, and how to handle SMO exceptions. The chapter concludes with a reference to all SMO classes used to programmatically administer data storage objects . Chapter 11 covers SMO classes for administering database objects that are not used to store data.

Programming SMO Instance Classes for Administering Data Storage Objects

The following SQL Server objects are considered to store data. They are used to identify the SMO instance classes that administer SQL Server data storage objects.

• SQL Server instances

• Databases

• Schemas

• Tables

• Views

• Columns

• Indexes

• Foreign keys

• Check constraints

• Rules

• Stored procedures, extended stored procedures, and numbered stored procedures

• DML and DDL triggers

• User-defined aggregates, user-defined functions, and user-defined types

• Data types

• System data types

Figure 10-1 shows the relationship between SMO instance classes used to administer the preceding list of SQL Server objects. A reference ...