Procedure Metadata

This table supplies information about the procedures in the virtual database.

Column Name	Type	Description
`VDBName`	string	VDB name
`SchemaName`	string	Schema name
`Name`	string	Procedure name
`NameInSource`	string	Procedure name in the source system
`ReturnsResults`	boolean	Returns a result set
`UID`	string	Procedure UID
`Description`	string	Description set at the Data Virtuality Server
`OriginalDescription`	string	Description from the data source
`OID`	integer	Unique ID
`Owner`	string	Name of the procedure owner
`ExecuteAs`	string	Executor of the procedure (CALLER or OWNER)

This supplies information on procedure parameters.

Column Name	Type	Description
`VDBName`	string	VDB name
`SchemaName`	string	Schema name
`ProcedureName`	string	Procedure name
`Name`	string	Parameter name
`DataType`	string	Data Virtuality Server runtime data type name
`Position`	integer	Position in procedure arguments
`Type`	string	Parameter direction: "`In`", "`Out`", "`InOut`", "`ResultSet`", "`ReturnValue`"
`Optional`	boolean	Parameter is optional
`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	Procedure UID
`Description`	string	Procedure description set at the Data Virtuality Server
`OriginalDescription`	string	Description from the data source
`OID`	string	Unique ID