PROCEDURE_NAME
Derby Reference Manual
308
schema for a Java procedure
· PROCEDURE_NAME
the name of the procedure
· COLUMN_NAME
the name of the parameter (see
column-Name-Pattern
)
· COLUMN_TYPE
short indicating what the row describes. Always is
DatabaseMetaData.procedureColumnIn for method parameters, unless the
parameter is an array. If so, it is DatabaseMetaData.procedureColumnInOut. It
always returns DatabaseMetaData.procedureColumnReturn for return values.
· TYPE_NAME
Derby-specific name for the type.
· NULLABLE
always returns DatabaseMetaData.procedureNoNulls for primitive parameters and
DatabaseMetaData.procedureNullable for object parameters
· REMARKS
a String describing the java type of the method parameter
· COLUMN_DEF
a String describing the default value for the column (may be null)
· SQL_DATA_TYPE
reserved by JDBC spec for future use
· SQL_DATETIME_SUB
reserved by JDBC spec for future use
· CHAR_OCTET_LENGTH
the maximum length of binary and character based columns (or any other datatype
the returned value is a NULL)
· ORDINAL_POSITION
the ordinal position, starting from 1, for the input and output parameters for a
procedure.
· IS_NULLABLE
a String describing the parameter's nullability (YES means parameter can include
NULLs, NO means it can't)
· SPECIFIC_NAME
the name which uniquely identifies this procedure within its schema
· METHOD_ID
a Derby-specific column.
· PARAMETER_ID
a Derby-specific column.
java.sql.DatabaseMetaData.getBestRowIdentifier method
The java.sql.DatabaseMetaData.getBestRowIdentifier method looks for identifiers in a
specific order. This order might not return a unique row.
The java.sql.DatabaseMetaData.getBestRowIdentifier method looks for identifiers in the
following order:
· A primary key on the table
· A unique constraint or unique index on the table
