MDSCHEMA_FUNCTIONS Rowset
Describes the functions available to client applications connected to the database.
Rowset Columns
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:
|
|
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.
Restriction Columns
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. |
See Also
Reference
OLE DB for OLAP Schema Rowsets