Collections

This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.

SQL Distributed Management Objects (SQL-DMO) collections are containers for objects of identical type. That is, the TypeOf property returns the same value for any object contained in a given collection. For example, the Tables collection contains only SQL-DMO Table objects.

All SQL-DMO collections expose the Application, Count, Parent, TypeOf, and UserData properties, and support the Item method. The Item method selects a contained object from the collection, using a supplied ordinal or name string to identify the desired collection member. For information about Item method variations, see each collection.

Properties

Count Property

TypeOf Property

Parent Property

UserData Property

Methods

Item Method