Collections
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.