Function Metadata

This table supplies information about the functions in the data sources and system schemas.

Column Name	Type	Description
`VDBName`	string	VDB name
`SchemaName`	string	Schema name
`Name`	string	Function name
`NameInSource`	string	Function name in the source system
`UID`	string	Function UID
`Description`	string	Description set by the user
`OriginalDescription`	string	Description set by the system
`IsVarArgs`	boolean	Whether the function accepts variable arguments or not

SYS.Functions table is available since v4.6

SYS.Functions contains information about data source functions since v4.8

OriginalDescription column is available since v4.8

This supplies information on function parameters.

Column Name	Type	Description
`VDBName`	string	VDB name
`SchemaName`	string	Schema name
`FunctionName`	string	Function name
`FunctionUID`	string	Function UID
`Name`	string	Parameter name
`DataType`	string	CData Virtuality Server runtime data type name
`Position`	integer	Position in function arguments
`Type`	string	Parameter direction: "`In`", "`Out`", "`InOut`", "`ResultSet`", "`ReturnValue`"
`Precision`	integer	Precision of parameter
`TypeLength`	integer	Length of the parameter value
`Scale`	integer	Scale of parameter
`Radix`	integer	Radix of parameter
`NullType`	string	Nullability: "`Nullable`", "`No Nulls`", "`Unknown`"
`UID`	string	Function UID
`Description`	string	Description set by the user
`OriginalDescription`	string	Description set by the system

SYS.FunctionParams table is available since v4.6

SYS.FunctionParams contains information about data source function parameters since v4.8

OriginalDescription column is available since v4.8