DatabaseMetaData

Indicates that NULL values might not be allowed.

A possible value for the column NULLABLE in the ResultSet object returned by the method getAttributes.

Indicates that NULL values are definitely allowed.

A possible value for the column NULLABLE in the ResultSet object returned by the method getAttributes.

Indicates that whether NULL values are allowed is not known.

A possible value for the column NULLABLE in the ResultSet object returned by the method getAttributes.

Indicates that the best row identifier is NOT a pseudo column.

A possible value for the column PSEUDO_COLUMN in the ResultSet object returned by the method getBestRowIdentifier.

Indicates that the best row identifier is a pseudo column.

A possible value for the column PSEUDO_COLUMN in the ResultSet object returned by the method getBestRowIdentifier.

Indicates that the scope of the best row identifier is the remainder of the current session.

A possible value for the column SCOPE in the ResultSet object returned by the method getBestRowIdentifier.

Indicates that the scope of the best row identifier is very temporary, lasting only while the row is being used.

A possible value for the column SCOPE in the ResultSet object returned by the method getBestRowIdentifier.

Indicates that the scope of the best row identifier is the remainder of the current transaction.

A possible value for the column SCOPE in the ResultSet object returned by the method getBestRowIdentifier.

Indicates that the best row identifier may or may not be a pseudo column.

A possible value for the column PSEUDO_COLUMN in the ResultSet object returned by the method getBestRowIdentifier.

Indicates that the column might not allow NULL values.

A possible value for the column NULLABLE in the ResultSet returned by the method getColumns.

Indicates that the column definitely allows NULL values.

A possible value for the column NULLABLE in the ResultSet returned by the method getColumns.

Indicates that the nullability of columns is unknown.

A possible value for the column NULLABLE in the ResultSet returned by the method getColumns.

Indicates that the parameter or column is an IN parameter.

A possible value for the column COLUMN_TYPE in the ResultSet returned by the method getFunctionColumns.

Indicates that the parameter or column is an INOUT parameter.

A possible value for the column COLUMN_TYPE in the ResultSet returned by the method getFunctionColumns.

Indicates that the parameter or column is an OUT parameter.

A possible value for the column COLUMN_TYPE in the ResultSet returned by the method getFunctionColumns.

Indicates that the parameter or column is a column in a result set.

A possible value for the column COLUMN_TYPE in the ResultSet returned by the method getFunctionColumns.

Indicates that type of the parameter or column is unknown.

A possible value for the column COLUMN_TYPE in the ResultSet returned by the method getFunctionColumns.

Indicates that NULL values are not allowed.

A possible value for the column NULLABLE in the ResultSet object returned by the method getFunctionColumns.

Indicates that the function does not return a table.

A possible value for column FUNCTION_TYPE in the ResultSet object returned by the method getFunctions.

Indicates that NULL values are allowed.

A possible value for the column NULLABLE in the ResultSet object returned by the method getFunctionColumns.

Indicates that whether NULL values are allowed is unknown.

A possible value for the column NULLABLE in the ResultSet object returned by the method getFunctionColumns.

Indicates that it is not known whether the function returns a result or a table.

A possible value for column FUNCTION_TYPE in the ResultSet object returned by the method getFunctions.

Indicates that the parameter or column is a return value.

A possible value for the column COLUMN_TYPE in the ResultSet returned by the method getFunctionColumns.

Indicates that the function returns a table.

A possible value for column FUNCTION_TYPE in the ResultSet object returned by the method getFunctions.

For the column UPDATE_RULE, indicates that when the primary key is updated, the foreign key (imported key) is changed to agree with it. For the column DELETE_RULE, it indicates that when the primary key is deleted, rows that imported that key are deleted.

A possible value for the columns UPDATE_RULE and DELETE_RULE in the ResultSet objects returned by the methods getImportedKeys, getExportedKeys, and getCrossReference.

Indicates deferrability. See SQL-92 for a definition.

A possible value for the column DEFERRABILITY in the ResultSet objects returned by the methods getImportedKeys, getExportedKeys, and getCrossReference.

Indicates deferrability. See SQL-92 for a definition.

A possible value for the column DEFERRABILITY in the ResultSet objects returned by the methods getImportedKeys, getExportedKeys, and getCrossReference.

For the columns UPDATE_RULE and DELETE_RULE, indicates that if the primary key has been imported, it cannot be updated or deleted.

A possible value for the columns UPDATE_RULE and DELETE_RULE in the ResultSet objects returned by the methods getImportedKeys, getExportedKeys, and getCrossReference.

Indicates deferrability. See SQL-92 for a definition.

A possible value for the column DEFERRABILITY in the ResultSet objects returned by the methods getImportedKeys, getExportedKeys, and getCrossReference.

For the column UPDATE_RULE, indicates that a primary key may not be updated if it has been imported by another table as a foreign key. For the column DELETE_RULE, indicates that a primary key may not be deleted if it has been imported by another table as a foreign key.

A possible value for the columns UPDATE_RULE and DELETE_RULE in the ResultSet objects returned by the methods getImportedKeys, getExportedKeys, and getCrossReference.

For the columns UPDATE_RULE and DELETE_RULE, indicates that if the primary key is updated or deleted, the foreign key (imported key) is set to the default value.

A possible value for the columns UPDATE_RULE and DELETE_RULE in the ResultSet objects returned by the methods getImportedKeys, getExportedKeys, and getCrossReference.

For the columns UPDATE_RULE and DELETE_RULE, indicates that when the primary key is updated or deleted, the foreign key (imported key) is changed to NULL.

A possible value for the columns UPDATE_RULE and DELETE_RULE in the ResultSet objects returned by the methods getImportedKeys, getExportedKeys, and getCrossReference.

Indicates that the column stores IN parameters.

A possible value for the column COLUMN_TYPE in the ResultSet returned by the method getProcedureColumns.

Indicates that the column stores INOUT parameters.

A possible value for the column COLUMN_TYPE in the ResultSet returned by the method getProcedureColumns.

Indicates that the column stores OUT parameters.

A possible value for the column COLUMN_TYPE in the ResultSet returned by the method getProcedureColumns.

Indicates that the column stores results.

A possible value for the column COLUMN_TYPE in the ResultSet returned by the method getProcedureColumns.

Indicates that the column stores return values.

A possible value for the column COLUMN_TYPE in the ResultSet returned by the method getProcedureColumns.

Indicates that type of the column is unknown.

A possible value for the column COLUMN_TYPE in the ResultSet returned by the method getProcedureColumns.

Indicates that NULL values are not allowed.

A possible value for the column NULLABLE in the ResultSet object returned by the method getProcedureColumns.

Indicates that the procedure does not return a result.

A possible value for column PROCEDURE_TYPE in the ResultSet object returned by the method getProcedures.

Indicates that NULL values are allowed.

A possible value for the column NULLABLE in the ResultSet object returned by the method getProcedureColumns.

Indicates that whether NULL values are allowed is unknown.

A possible value for the column NULLABLE in the ResultSet object returned by the method getProcedureColumns.

Indicates that it is not known whether the procedure returns a result.

A possible value for column PROCEDURE_TYPE in the ResultSet object returned by the method getProcedures.

Indicates that the procedure returns a result.

A possible value for column PROCEDURE_TYPE in the ResultSet object returned by the method getProcedures.

A possible return value for the method DatabaseMetaData.getSQLStateType which is used to indicate whether the value returned by the method SQLException.getSQLState is an SQLSTATE value.

A possible return value for the method DatabaseMetaData.getSQLStateType which is used to indicate whether the value returned by the method SQLException.getSQLState is an SQL99 SQLSTATE value.

Note:This constant remains only for compatibility reasons. Developers should use the constant sqlStateSQL instead.

A possible return value for the method DatabaseMetaData.getSQLStateType which is used to indicate whether the value returned by the method SQLException.getSQLState is an X/Open (now know as Open Group) SQL CLI SQLSTATE value.

Indicates that this table index is a clustered index.

A possible value for column TYPE in the ResultSet object returned by the method getIndexInfo.

Indicates that this table index is a hashed index.

A possible value for column TYPE in the ResultSet object returned by the method getIndexInfo.

Indicates that this table index is not a clustered index, a hashed index, or table statistics; it is something other than these.

A possible value for column TYPE in the ResultSet object returned by the method getIndexInfo.

Indicates that this column contains table statistics that are returned in conjunction with a table's index descriptions.

A possible value for column TYPE in the ResultSet object returned by the method getIndexInfo.

Indicates that a NULL value is NOT allowed for this data type.

A possible value for column NULLABLE in the ResultSet object returned by the method getTypeInfo.

Indicates that a NULL value is allowed for this data type.

A possible value for column NULLABLE in the ResultSet object returned by the method getTypeInfo.

Indicates that it is not known whether a NULL value is allowed for this data type.

A possible value for column NULLABLE in the ResultSet object returned by the method getTypeInfo.

Indicates that the data type can be only be used in WHERE search clauses that do not use LIKE predicates.

A possible value for column SEARCHABLE in the ResultSet object returned by the method getTypeInfo.

Indicates that the data type can be only be used in WHERE search clauses that use LIKE predicates.

A possible value for column SEARCHABLE in the ResultSet object returned by the method getTypeInfo.

Indicates that WHERE search clauses are not supported for this type.

A possible value for column SEARCHABLE in the ResultSet object returned by the method getTypeInfo.

Indicates that all WHERE search clauses can be based on this type.

A possible value for column SEARCHABLE in the ResultSet object returned by the method getTypeInfo.

Indicates that this version column is NOT a pseudo column.

A possible value for the column PSEUDO_COLUMN in the ResultSet object returned by the method getVersionColumns.

Indicates that this version column is a pseudo column.

A possible value for the column PSEUDO_COLUMN in the ResultSet object returned by the method getVersionColumns.

Indicates that this version column may or may not be a pseudo column.

A possible value for the column PSEUDO_COLUMN in the ResultSet object returned by the method getVersionColumns.