Properties Collection

OLE Automation controllers, such as Microsoft® Visual Basic®, commonly expose properties using an object. Visual Basic, Visual Basic for Applications, and Microsoft ActiveX® implement a Property object and a containing Properties collection. When using the Property object and Properties collection, the application can retrieve information about SQL-DMO object properties.

Like any other OLE Automation objects, the Property object and Properties collection expose properties and methods. For example, Name, Value, and Type are all properties of a Property object. Count is a property of the Properties collection, and the collection exposes the Item method.

For more information about the Property object and the Properties collection, see the OLE Automation controller documentation.

For a detailed example of the Properties collection and its use, see the SQL-DMO Visual Basic sample Explore.