# 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.

Parent topic: java.sql.DatabaseMetaData interface
Related reference
DatabaseMetaData result sets
java.sql.DatabaseMetaData.getBestRowIdentifier method