Collections
Esta característica se quitará en una versión futura de Microsoft SQL Server. Evite utilizar esta característica en nuevos trabajos de desarrollo y tenga previsto modificar las aplicaciones que actualmente la utilizan.
SQL Distributed Management Objects (SQL-DMO) collections are containers for objects of identical type. That is, the TypeOfproperty 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 UserDataproperties, 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.