MDSCHEMA_FUNCTIONS Rowset

MDSCHEMA_FUNCTIONS Rowset

 

Applies To: SQL Server 2016 Preview

Describes the functions available to client applications connected to the database.

The MDSCHEMA_FUNCTIONS rowset contains the following columns.

Column nameType indicatorDescription
FUNCTION_NAMEDBTYPE_WSTRThe name of the function.
DESCRIPTIONDBTYPE_WSTRA description of the function.
PARAMETER_LISTDBTYPE_WSTRA comma delimited list of parameters formatted as in Microsoft Visual Basic. For example, a parameter might be Name as String.
RETURN_TYPEDBTYPE_I4The VARTYPE of the return data type of the function.
ORIGINDBTYPE_I4The origin of the function:

1 for MDX functions.

2 for user-defined functions.
INTERFACE_NAMEDBTYPE_WSTRThe name of the interface for user-defined functions

The group name for Multidimensional Expressions (MDX) functions.
LIBRARY_NAMEDBTYPE_WSTRThe name of the type library for user-defined functions. NULL for MDX functions.
DLL_NAMEDBTYPE_WSTR(Optional) The name of the assembly that implements the user-defined function.

Returns VT_NULL for MDX functions.
HELP_FILEDBTYPE_WSTR(Optional) The name of the file that contains the help documentation for the user-defined function.

Returns VT_NULL for MDX functions.
HELP_CONTEXTDBTYPE_I4(Optional) Returns the Help context ID for this function.
OBJECTDBTYPE_WSTR(Optional) The generic name of the object class to which a property applies. For example, the rowset corresponding to the <level_name>.Members function returns "Level".

Returns VT_NULL for user-defined functions, or non-property MDX functions.
CAPTIONDBTYPE_WSTRThe display caption for the function.

The rowset is sorted on ORIGIN, INTERFACE_NAME, FUNCTION_NAME.

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

Column nameType indicatorRestriction State
LIBRARY_NAMEDBTYPE_WSTROptional.
INTERFACE_NAMEDBTYPE_WSTROptional.
FUNCTION_NAMEDBTYPE_WSTROptional.
ORIGINDBTYPE_I4Optional.

OLE DB for OLAP Schema Rowsets

Community Additions

ADD
Show:
© 2016 Microsoft