Share via


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.