RootIfValues

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.

Enumerates values for the RootMemberIf property.

Constant	Description
rootifParentIsBlank	Only members with a null, a zero, or an empty string in their ParentKeyColumn are treated as root members.
rootifParentIsBlankOrSelfOrMissing	Members are treated as root members if they meet one or more of the conditions specified by rootifParentIsBlank, rootifParentIsSelf, or rootifParentIsMissing.
rootifParentIsMissing	Only members with parents that cannot be found are treated as root members.
rootifParentIsSelf	Only members with themselves as parents are treated as root members.