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