DISCOVER_LITERALS Rowset

APPLIES TO:yesSQL Server Analysis ServicesnoAzure Analysis Services

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.

Rowset Columns

The DISCOVER_LITERALS rowset contains the following columns.

Column name Type indicator Length Description
LiteralName DBTYPE_WSTR The name of the literal described in the row.

For example: DBLITERAL_LIKE_PERCENT
LiteralValue DBTYPE_WSTR An 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 "%".
LiteralInvalidChars DBTYPE_WSTR The 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".
LiteralInvalidStartingChars DBTYPE_WSTR The characters that are not valid as the first character of the literal. If the literal can start with any valid character, this is null.
LiteralMaxLength DBTYPE_I4 The maximum number of characters in the literal. If there is no maximum or the maximum is unknown, the value is –1.
LiteralNameEnumValue DBTYPE_I4

This schema rowset is not sorted.

Restriction Columns

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

Column name Type indicator Restriction State
LiteralName DBTYPE_WSTR Optional.

See Also

XML for Analysis Schema Rowsets
DISCOVER_KEYWORDS Rowset (XMLA)