Share via

  • Article

Remove (clsCollection)

Note

  This feature will be removed in the next version of Microsoft SQL Server. Do not use this feature in new development work, and modify applications that currently use this feature as soon as possible.

The Remove method of a Decision Support Objects (DSO) collection removes an item from the collection. This method does not apply to CustomProperties collections.

Syntax

object.Remove(vntIndexKey)

Parameters

  • object
    An instance of a DSO collection object.

  • vntIndexKey
    Either the index (integer) or key (string) to the collection.

    Note

      All collections in the DSO object model are one-based. That is, the first item in the collection has an index of 1 and the last item has an index of Count.

Remarks

The Remove method, by removing the selected member from the collection, removes the selected member from both the Analysis server and the repository.

Example

Use the following code to remove the partition named EastCoast from the MDStores collection of partitions for a cube:

' Assume the existence of an object dsoCube
' of ClassType clsCube.
' Remove using the key 
dsoCube.MDStores.Remove "EastCoast" 
' OR Remove using the Index
dsoCube.MDStores.Remove 2

See Also

Reference

Collections