Collection Properties

SQL-DMO

SQL-DMO

Collection Properties

All SQL-DMO collections expose the Count and TypeOf properties.

The Count property returns the number of members in a collection and is often used for application control-of-flow logic, for example, in a for...next loop.

For SQL-DMO collections, the TypeOf property reports the TypeOf property value for the objects contained within the collection. For example, the TypeOf property value for the Databases collection returns SQLDMOObj_Database, which is the TypeOf property value of a Database object.

All SQL-DMO collection properties are read-only.