Collections

后续版本的 Microsoft SQL Server 将删除该功能。请避免在新的开发工作中使用该功能,并着手修改当前还在使用该功能的应用程序。

SQL Distributed Management Objects (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.

Properties

Count Property

TypeOf Property

Parent Property

UserData Property

Methods

Item Method