Columns in the ResultSets returned by getFunctionColumns and getProcedureColumns

Columns in the ResultSets returned by getFunctionColumns and getProcedureColumns are as described by the API.

The following table shows Derby-specific details for some specific columns returned by getFunctionColumns.

Table 1. Columns in the ResultSet returned by getFunctionColumns
Column Description
COLUMN_TYPE A short indicating what the row describes. Is always DatabaseMetaData.functionColumnIn if it represents a parameter; DatabaseMetaData.functionReturn if it represents a return value; and DatabaseMetaData.functionColumnResult if it represents a column in a table function.
TYPE_NAME Derby-specific name for the type.
NULLABLE Always returns DatabaseMetaData.functionNullable.
REMARKS A String which describes the Java type of the method parameter.
ORDINAL_POSITION The ordinal position, starting from 1, for the input and output parameters for the function.
METHOD_ID A Derby-specific column.
PARAMETER_ID A Derby-specific column.

The following table shows Derby-specific details for some specific columns returned by getProcedureColumns.

Table 2. Columns in the ResultSet returned by getProcedureColumns
Column Description
COLUMN_TYPE A short indicating what the row describes. Is always DatabaseMetaData.procedureColumnIn if the parameter is (possibly implicitly) declared as an IN parameter; DatabaseMetaData.procedureColumnInOut if the parameter is declared as an INOUT parameter; and DatabaseMetaData.procedureColumnOut if the parameter is declared as an OUT parameter.
TYPE_NAME Derby-specific name for the type.
NULLABLE Always returns DatabaseMetaData.procedureNullable.
REMARKS A String which describes the Java type of the method parameter.
ORDINAL_POSITION The ordinal position, starting from 1, for the input and output parameters for the procedure.
METHOD_ID A Derby-specific column.
PARAMETER_ID A Derby-specific column.
Related reference
DatabaseMetaData result sets
java.sql.DatabaseMetaData.getBestRowIdentifier method
java.sql.DatabaseMetaData.getMaxLogicalLOBSize method