Fields

The fields of Java.Sql.DatabaseMetaData are listed below. For a list of all members, see the DatabaseMetaData Members list.

Public Fields

const	AttributeNoNulls	short (0). States that it may not be permitted to store `NULL` values.
const	AttributeNullable	short (1). States that `NULL` values are definitely permitted.
const	AttributeNullableUnknown	short (2). States that whether `NULL` values are permitted is unknown.
const	BestRowNotPseudo	int (1). States the best row identifier is NOT a pseudo column.
const	BestRowPseudo	int (2). States that the best row identifier is a pseudo column.
const	BestRowSession	int (2). States that the remainder of the current session is used as the scope for the best row identifier.
const	BestRowTemporary	int (0). States that best row identifier scope lasts only while the row is being used.
const	BestRowTransaction	int (1). States that the remainder of the current transaction is used as the scope for the best row identifier.
const	BestRowUnknown	int (0). States that the best row identifier may or may not be a pseudo column.
const	ColumnNoNulls	int (0). States that the column must not allow `NULL` values.
const	ColumnNullable	int (1). States that the column definitely allows `NULL` values.
const	ColumnNullableUnknown	int (2). States that it is unknown whether the columns may be nulled.
const	ImportedKeyCascade	int (0). For the column `UPDATE_RULE`, states that when the primary key is updated, the foreign key (imported key) is changed accordingly.
const	ImportedKeyInitiallyDeferred	int (5). States that the evaluation of foreign key constraints is deferred (delayed until commit).
const	ImportedKeyInitiallyImmediate	int (6). States that the evaluation of foreign key constraint is `IMMEDIATE` .
const	ImportedKeyNoAction	int (3). For the columns `UPDATE_RULE` and `DELETE_RULE`, states that if the primary key has been imported, it cannot be updated or deleted.
const	ImportedKeyNotDeferrable	int (7). States that the evaluation of foreign key constraint must not be `DEFERRED`.
const	ImportedKeyRestrict	int (1). States that a primary key must not be updated when imported as a foreign key by some other table.
const	ImportedKeySetDefault	int (4). States that when the primary key is modified (updated or deleted) the foreign (imported) key is changed to its default value.
const	ImportedKeySetNull	int (2). States that when the primary key is modified (updated or deleted) the foreign (imported) key is changed to `NULL`.
const	ProcedureColumnIn	int (1). States that the column stores `IN` type parameters.
const	ProcedureColumnInOut	int (2). States that this column stores `INOUT` type parameters.
const	ProcedureColumnOut	int (4). States that this column stores `OUT` type parameters.
const	ProcedureColumnResult	int (3). States that the column stores results.
const	ProcedureColumnReturn	int (5). States that the column stores return values.
const	ProcedureColumnUnknown	int (0). States that type of the column is unknown.
const	ProcedureNoNulls	int (0). States that `NULL` values are not permitted.
const	ProcedureNoResult	int (1). States that the procedure does not return a result.
const	ProcedureNullable	int (1). States that `NULL` values are permitted.
const	ProcedureNullableUnknown	int (2). States that it is unknown whether `NULL` values are permitted.
const	ProcedureResultUnknown	int (0). States that it is unknown whether or not the procedure returns a result.
const	ProcedureReturnsResult	int (2). States that the procedure returns a result.
const	SqlStateSQL99	int (2). States that the value is an SQL99 `SQLSTATE` value.
const	SqlStateXOpen	int (1). States that the value is an SQL `CLI SQLSTATE` value as defined by the X/Open standard.
const	TableIndexClustered	short (1). States that this table index is a clustered index.
const	TableIndexHashed	short (2). States that this table index is a hashed index.
const	TableIndexOther	short (3). States this table's index is neither a clustered index, not a hashed index, and not a table statistics index; i.e. it is something else.
const	TableIndexStatistic	short (0). States this column has the table's statistics, and that it is returned in conjunction with the table's index description.
const	TypeNoNulls	int (0). States that a `NULL` value is NOT permitted for this data type.
const	TypeNullable	int (1). States that a `NULL` value is permitted for this data type.
const	TypeNullableUnknown	int (2). States that it is unknown if a `NULL` value is permitted for this data type.
const	TypePredBasic	int (2). States that this column shall not be used for `WHERE` statements with a `LIKE` clause.
const	TypePredChar	int (1). States that this column can only be used in a `WHERE...LIKE` statement.
const	TypePredNone	int (0). States that this column does not support searches.
const	TypeSearchable	int (3). States that the column is searchable.
const	VersionColumnNotPseudo	int (1). States that the version column is known to be not a pseudo column.
const	VersionColumnPseudo	int (2). States that this version column is known to be a pseudo column.
const	VersionColumnUnknown	int (0). States that the version column may be a pseudo column or not.