Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

MDSCHEMA_FUNCTIONS Rowset

Topic Status: Some information in this topic is preview and subject to change in future releases. Preview information describes new features or changes to existing features in Microsoft SQL Server 2016 Community Technology Preview 2 (CTP2).

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

The MDSCHEMA_FUNCTIONS rowset contains the following columns.

Column name

Type indicator

Length

Description

FUNCTION_NAME

DBTYPE_WSTR

The name of the function.

DESCRIPTION

DBTYPE_WSTR

A description of the function.

PARAMETER_LIST

DBTYPE_WSTR

A comma delimited list of parameters formatted as in Microsoft Visual Basic. For example, a parameter might be Name as String.

RETURN_TYPE

DBTYPE_I4

The VARTYPE of the return data type of the function.

ORIGIN

DBTYPE_I4

The origin of the function:

  • 1 for MDX functions.

  • 2 for user-defined functions.

INTERFACE_NAME

DBTYPE_WSTR

The name of the interface for user-defined functions

The group name for Multidimensional Expressions (MDX) functions.

LIBRARY_NAME

DBTYPE_WSTR

The name of the type library for user-defined functions. NULL for MDX functions.

DLL_NAME

DBTYPE_WSTR

(Optional) The name of the assembly that implements the user-defined function.

Returns VT_NULL for MDX functions.

HELP_FILE

DBTYPE_WSTR

(Optional) The name of the file that contains the help documentation for the user-defined function.

Returns VT_NULL for MDX functions.

HELP_CONTEXT

DBTYPE_I4

(Optional) Returns the Help context ID for this function.

OBJECT

DBTYPE_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.

CAPTION

DBTYPE_WSTR

The 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 name

Type indicator

Restriction State

LIBRARY_NAME

DBTYPE_WSTR

Optional.

INTERFACE_NAME

DBTYPE_WSTR

Optional.

FUNCTION_NAME

DBTYPE_WSTR

Optional.

ORIGIN

DBTYPE_I4

Optional.

Community Additions

ADD
Show:
© 2015 Microsoft