Collections
Esse recurso será removido em uma versão futura do Microsoft SQL Server. Evite usar esse recurso em desenvolvimentos novos e planeje modificar os aplicativos que atualmente o utilizam.
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.