Collections

未來的 Microsoft SQL Server 版本將移除這項功能。請避免在新的開發工作中使用這項功能，並規劃修改目前使用這項功能的應用程式。

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.