TechNet
Export (0) Print
Expand All

DISCOVER_LITERALS Rowset

 

Applies To: SQL Server 2016 Preview

Returns information about literals, including data types and values, supported by the Microsoft XML for Analysis (XMLA) provider.

If you call the Discover method with the DISCOVER_LITERALS enumeration value in the RequestType element, the Discover method returns the DISCOVER_LITERALS rowset.

The DISCOVER_LITERALS rowset contains the following columns.

Column nameType indicatorLengthDescription
LiteralNameDBTYPE_WSTRThe name of the literal described in the row.

For example: DBLITERAL_LIKE_PERCENT
LiteralValueDBTYPE_WSTRAn actual literal value.

For example, if LiteralName is DBLITERAL_LIKE_PERCENT and the percent character (%) matches zero or more characters in a LIKE clause, the value of the LiteralValue column is "%".
LiteralInvalidCharsDBTYPE_WSTRThe characters that are not valid in the literal.

For example, if table names can contain anything other than a numeric character, this string is "0123456789".
LiteralInvalidStartingCharsDBTYPE_WSTRThe characters that are not valid as the first character of the literal. If the literal can start with any valid character, this is null.
LiteralMaxLengthDBTYPE_I4The maximum number of characters in the literal. If there is no maximum or the maximum is unknown, the value is –1.
LiteralNameEnumValueDBTYPE_I4

This schema rowset is not sorted.

The DISCOVER_LITERALS rowset can be restricted on the columns in the following table.

Column nameType indicatorRestriction State
LiteralNameDBTYPE_WSTROptional.

XML for Analysis Schema Rowsets
DISCOVER_KEYWORDS Rowset (XMLA)

Community Additions

ADD
Show:
© 2016 Microsoft