Note
Access to this page requires authorization. You can try signing in or changing directories.
Access to this page requires authorization. You can try changing directories.
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