Collection Type ("M" Reference)

[This content is no longer valid. For the latest information on "M", "Quadrant", SQL Server Modeling Services, and the Repository, see the Model Citizen blog.]

The Collection type is an unordered group of potentially duplicate values.

Operators

The unary postfix operator in the following table takes Collection as a left operand.

Operator	Return
#	Integer

The binary operators in the following table take Collection as a left operand.

Operator	Right Operand	Return
>, <, <=, >=, ==, !=	Collection	Logical
where	Logical	Collection
select	Any	Collection
&, |, \	Collection	Collection

Functions

The functions in the following table are defined on all Collections.

Function	Description
Count()	Returns the total number of elements in a collection.
Distinct()	Removes all duplicates in a collection.

Code Example

The following code shows the Employees field being declared as a Collection of Text types and receiving the values "Josh Barnhill" and "Andy Jacobs".

Employees : Text* {"Josh Barnhill", "Andy Jacobs"};