API Overview API Index Package Overview Direct link to this page
JDK 1.6
  java.sql. DatabaseMetaData View Source
Author(s)
Since
Version
Serial
Hierarchy
 Wrapper
      DatabaseMetaData
Subinterfaces
Description
public interface DatabaseMetaData
  Comprehensive information about the database as a whole.
See also:   
Methods
Hide/Show inherited methods
public boolean allProceduresAreCallable () throws SQLException
  Retrieves whether the current user can call all the procedures returned by the method getProcedures.
public boolean allTablesAreSelectable () throws SQLException
  Retrieves whether the current user can use all the tables returned by the method getTables in a SELECT statement.
public boolean autoCommitFailureClosesAllResultSets () throws SQLException
  Retrieves whether a SQLException while autoCommit is true inidcates that all open ResultSets are closed, even ones that are holdable.
public boolean dataDefinitionCausesTransactionCommit () throws SQLException
  Retrieves whether a data definition statement within a transaction forces the transaction to commit.
public boolean dataDefinitionIgnoredInTransactions () throws SQLException
  Retrieves whether this database ignores a data definition statement within a transaction.
public boolean deletesAreDetected (int type) throws SQLException
  Retrieves whether or not a visible row delete can be detected by calling the method ResultSet.rowDeleted.
public boolean doesMaxRowSizeIncludeBlobs () throws SQLException
  Retrieves whether the return value for the method getMaxRowSize includes the SQL data types LONGVARCHAR and LONGVARBINARY.
public ResultSet getAttributes (String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern) throws SQLException
  Retrieves a description of the given attribute of the given type for a user-defined type (UDT) that is available in the given schema and catalog.
public ResultSet getBestRowIdentifier (String catalog, String schema, String table, int scope, boolean nullable) throws SQLException
  Retrieves a description of a table's optimal set of columns that uniquely identifies a row.
public ResultSet getCatalogs () throws SQLException
  Retrieves the catalog names available in this database.
public String getCatalogSeparator () throws SQLException
  Retrieves the String that this database uses as the separator between a catalog and table name.
public String getCatalogTerm () throws SQLException
  Retrieves the database vendor's preferred term for "catalog".
public ResultSet getClientInfoProperties () throws SQLException
  Retrieves a list of the client info properties that the driver supports.
public ResultSet getColumnPrivileges (String catalog, String schema, String table, String columnNamePattern) throws SQLException
  Retrieves a description of the access rights for a table's columns.
public ResultSet getColumns (String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) throws SQLException
  Retrieves a description of table columns available in the specified catalog.
public Connection getConnection () throws SQLException
  Retrieves the connection that produced this metadata object.
public ResultSet getCrossReference (String parentCatalog, String parentSchema, String parentTable, String foreignCatalog, String foreignSchema, String foreignTable) throws SQLException
  Retrieves a description of the foreign key columns in the given foreign key table that reference the primary key or the columns representing a unique constraint of the parent table (could be the same or a different table).
public int getDatabaseMajorVersion () throws SQLException
  Retrieves the major version number of the underlying database.
public int getDatabaseMinorVersion () throws SQLException
  Retrieves the minor version number of the underlying database.
public String getDatabaseProductName () throws SQLException
  Retrieves the name of this database product.
public String getDatabaseProductVersion () throws SQLException
  Retrieves the version number of this database product.
public int getDefaultTransactionIsolation () throws SQLException
  Retrieves this database's default transaction isolation level.
public int getDriverMajorVersion ()
  Retrieves this JDBC driver's major version number.
public int getDriverMinorVersion ()
  Retrieves this JDBC driver's minor version number.
public String getDriverName () throws SQLException
  Retrieves the name of this JDBC driver.
public String getDriverVersion () throws SQLException
  Retrieves the version number of this JDBC driver as a String.
public ResultSet getExportedKeys (String catalog, String schema, String table) throws SQLException
  Retrieves a description of the foreign key columns that reference the given table's primary key columns (the foreign keys exported by a table).
public String getExtraNameCharacters () throws SQLException
  Retrieves all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _).
public ResultSet getFunctionColumns (String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern) throws SQLException
  Retrieves a description of the given catalog's system or user function parameters and return type.
public ResultSet getFunctions (String catalog, String schemaPattern, String functionNamePattern) throws SQLException
  Retrieves a description of the system and user functions available in the given catalog.
public String getIdentifierQuoteString () throws SQLException
  Retrieves the string used to quote SQL identifiers.
public ResultSet getImportedKeys (String catalog, String schema, String table) throws SQLException
  Retrieves a description of the primary key columns that are referenced by the given table's foreign key columns (the primary keys imported by a table).
public ResultSet getIndexInfo (String catalog, String schema, String table, boolean unique, boolean approximate) throws SQLException
  Retrieves a description of the given table's indices and statistics.
public int getJDBCMajorVersion () throws SQLException
  Retrieves the major JDBC version number for this driver.
public int getJDBCMinorVersion () throws SQLException
  Retrieves the minor JDBC version number for this driver.
public int getMaxBinaryLiteralLength () throws SQLException
  Retrieves the maximum number of hex characters this database allows in an inline binary literal.
public int getMaxCatalogNameLength () throws SQLException
  Retrieves the maximum number of characters that this database allows in a catalog name.
public int getMaxCharLiteralLength () throws SQLException
  Retrieves the maximum number of characters this database allows for a character literal.
public int getMaxColumnNameLength () throws SQLException
  Retrieves the maximum number of characters this database allows for a column name.
public int getMaxColumnsInGroupBy () throws SQLException
  Retrieves the maximum number of columns this database allows in a GROUP BY clause.
public int getMaxColumnsInIndex () throws SQLException
  Retrieves the maximum number of columns this database allows in an index.
public int getMaxColumnsInOrderBy () throws SQLException
  Retrieves the maximum number of columns this database allows in an ORDER BY clause.
public int getMaxColumnsInSelect () throws SQLException
  Retrieves the maximum number of columns this database allows in a SELECT list.
public int getMaxColumnsInTable () throws SQLException
  Retrieves the maximum number of columns this database allows in a table.
public int getMaxConnections () throws SQLException
  Retrieves the maximum number of concurrent connections to this database that are possible.
public int getMaxCursorNameLength () throws SQLException
  Retrieves the maximum number of characters that this database allows in a cursor name.
public int getMaxIndexLength () throws SQLException
  Retrieves the maximum number of bytes this database allows for an index, including all of the parts of the index.
public int getMaxProcedureNameLength () throws SQLException
  Retrieves the maximum number of characters that this database allows in a procedure name.
public int getMaxRowSize () throws SQLException
  Retrieves the maximum number of bytes this database allows in a single row.
public int getMaxSchemaNameLength () throws SQLException
  Retrieves the maximum number of characters that this database allows in a schema name.
public int getMaxStatementLength () throws SQLException
  Retrieves the maximum number of characters this database allows in an SQL statement.
public int getMaxStatements () throws SQLException
  Retrieves the maximum number of active statements to this database that can be open at the same time.
public int getMaxTableNameLength () throws SQLException
  Retrieves the maximum number of characters this database allows in a table name.
public int getMaxTablesInSelect () throws SQLException
  Retrieves the maximum number of tables this database allows in a SELECT statement.
public int getMaxUserNameLength () throws SQLException
  Retrieves the maximum number of characters this database allows in a user name.
public String getNumericFunctions () throws SQLException
  Retrieves a comma-separated list of math functions available with this database.
public ResultSet getPrimaryKeys (String catalog, String schema, String table) throws SQLException
  Retrieves a description of the given table's primary key columns.
public ResultSet getProcedureColumns (String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) throws SQLException
  Retrieves a description of the given catalog's stored procedure parameter and result columns.
public ResultSet getProcedures (String catalog, String schemaPattern, String procedureNamePattern) throws SQLException
  Retrieves a description of the stored procedures available in the given catalog.
public String getProcedureTerm () throws SQLException
  Retrieves the database vendor's preferred term for "procedure".
public int getResultSetHoldability () throws SQLException
  Retrieves this database's default holdability for ResultSet objects.
public RowIdLifetime getRowIdLifetime () throws SQLException
  Indicates whether or not this data source supports the SQL ROWID type, and if so the lifetime for which a RowId object remains valid.
public ResultSet getSchemas () throws SQLException
  Retrieves the schema names available in this database.
public ResultSet getSchemas (String catalog, String schemaPattern) throws SQLException
  Retrieves the schema names available in this database.
public String getSchemaTerm () throws SQLException
  Retrieves the database vendor's preferred term for "schema".
public String getSearchStringEscape () throws SQLException
  Retrieves the string that can be used to escape wildcard characters.
public String getSQLKeywords () throws SQLException
  Retrieves a comma-separated list of all of this database's SQL keywords that are NOT also SQL:2003 keywords.
public int getSQLStateType () throws SQLException
  Indicates whether the SQLSTATE returned by SQLException.getSQLState is X/Open (now known as Open Group) SQL CLI or SQL:2003.
public String getStringFunctions () throws SQLException
  Retrieves a comma-separated list of string functions available with this database.
public ResultSet getSuperTables (String catalog, String schemaPattern, String tableNamePattern) throws SQLException
  Retrieves a description of the table hierarchies defined in a particular schema in this database.
public ResultSet getSuperTypes (String catalog, String schemaPattern, String typeNamePattern) throws SQLException
  Retrieves a description of the user-defined type (UDT) hierarchies defined in a particular schema in this database.
public String getSystemFunctions () throws SQLException
  Retrieves a comma-separated list of system functions available with this database.
public ResultSet getTablePrivileges (String catalog, String schemaPattern, String tableNamePattern) throws SQLException
  Retrieves a description of the access rights for each table available in a catalog.
public ResultSet getTables (String catalog, String schemaPattern, String tableNamePattern, String types) throws SQLException
  Retrieves a description of the tables available in the given catalog.
public ResultSet getTableTypes () throws SQLException
  Retrieves the table types available in this database.
public String getTimeDateFunctions () throws SQLException
  Retrieves a comma-separated list of the time and date functions available with this database.
public ResultSet getTypeInfo () throws SQLException
  Retrieves a description of all the data types supported by this database.
public ResultSet getUDTs (String catalog, String schemaPattern, String typeNamePattern, int[] types) throws SQLException
  Retrieves a description of the user-defined types (UDTs) defined in a particular schema.
public String getURL () throws SQLException
  Retrieves the URL for this DBMS.
public String getUserName () throws SQLException
  Retrieves the user name as known to this database.
public ResultSet getVersionColumns (String catalog, String schema, String table) throws SQLException
  Retrieves a description of a table's columns that are automatically updated when any value in a row is updated.
public boolean insertsAreDetected (int type) throws SQLException
  Retrieves whether or not a visible row insert can be detected by calling the method ResultSet.rowInserted.
public boolean isCatalogAtStart () throws SQLException
  Retrieves whether a catalog appears at the start of a fully qualified table name.
public boolean isReadOnly () throws SQLException
  Retrieves whether this database is in read-only mode.
public boolean locatorsUpdateCopy () throws SQLException
  Indicates whether updates made to a LOB are made on a copy or directly to the LOB.
public boolean nullPlusNonNullIsNull () throws SQLException
  Retrieves whether this database supports concatenations between NULL and non-NULL values being NULL.
public boolean nullsAreSortedAtEnd () throws SQLException
  Retrieves whether NULL values are sorted at the end regardless of sort order.
public boolean nullsAreSortedAtStart () throws SQLException
  Retrieves whether NULL values are sorted at the start regardless of sort order.
public boolean nullsAreSortedHigh () throws SQLException
  Retrieves whether NULL values are sorted high.
public boolean nullsAreSortedLow () throws SQLException
  Retrieves whether NULL values are sorted low.
public boolean othersDeletesAreVisible (int type) throws SQLException
  Retrieves whether deletes made by others are visible.
public boolean othersInsertsAreVisible (int type) throws SQLException
  Retrieves whether inserts made by others are visible.
public boolean othersUpdatesAreVisible (int type) throws SQLException
  Retrieves whether updates made by others are visible.
public boolean ownDeletesAreVisible (int type) throws SQLException
  Retrieves whether a result set's own deletes are visible.
public boolean ownInsertsAreVisible (int type) throws SQLException
  Retrieves whether a result set's own inserts are visible.
public boolean ownUpdatesAreVisible (int type) throws SQLException
  Retrieves whether for the given type of ResultSet object, the result set's own updates are visible.
public boolean storesLowerCaseIdentifiers () throws SQLException
  Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in lower case.
public boolean storesLowerCaseQuotedIdentifiers () throws SQLException
  Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in lower case.
public boolean storesMixedCaseIdentifiers () throws SQLException
  Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case.
public boolean storesMixedCaseQuotedIdentifiers () throws SQLException
  Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in mixed case.
public boolean storesUpperCaseIdentifiers () throws SQLException
  Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in upper case.
public boolean storesUpperCaseQuotedIdentifiers () throws SQLException
  Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in upper case.
public boolean supportsAlterTableWithAddColumn () throws SQLException
  Retrieves whether this database supports ALTER TABLE with add column.
public boolean supportsAlterTableWithDropColumn () throws SQLException
  Retrieves whether this database supports ALTER TABLE with drop column.
public boolean supportsANSI92EntryLevelSQL () throws SQLException
  Retrieves whether this database supports the ANSI92 entry level SQL grammar.
public boolean supportsANSI92FullSQL () throws SQLException
  Retrieves whether this database supports the ANSI92 full SQL grammar supported.
public boolean supportsANSI92IntermediateSQL () throws SQLException
  Retrieves whether this database supports the ANSI92 intermediate SQL grammar supported.
public boolean supportsBatchUpdates () throws SQLException
  Retrieves whether this database supports batch updates.
public boolean supportsCatalogsInDataManipulation () throws SQLException
  Retrieves whether a catalog name can be used in a data manipulation statement.
public boolean supportsCatalogsInIndexDefinitions () throws SQLException
  Retrieves whether a catalog name can be used in an index definition statement.
public boolean supportsCatalogsInPrivilegeDefinitions () throws SQLException
  Retrieves whether a catalog name can be used in a privilege definition statement.
public boolean supportsCatalogsInProcedureCalls () throws SQLException
  Retrieves whether a catalog name can be used in a procedure call statement.
public boolean supportsCatalogsInTableDefinitions () throws SQLException
  Retrieves whether a catalog name can be used in a table definition statement.
public boolean supportsColumnAliasing () throws SQLException
  Retrieves whether this database supports column aliasing.
public boolean supportsConvert () throws SQLException
  Retrieves whether this database supports the JDBC scalar function CONVERT for the conversion of one JDBC type to another.
public boolean supportsConvert (int fromType, int toType) throws SQLException
  Retrieves whether this database supports the JDBC scalar function CONVERT for conversions between the JDBC types fromType and toType.
public boolean supportsCoreSQLGrammar () throws SQLException
  Retrieves whether this database supports the ODBC Core SQL grammar.
public boolean supportsCorrelatedSubqueries () throws SQLException
  Retrieves whether this database supports correlated subqueries.
public boolean supportsDataDefinitionAndDataManipulationTransactions () throws SQLException
  Retrieves whether this database supports both data definition and data manipulation statements within a transaction.
public boolean supportsDataManipulationTransactionsOnly () throws SQLException
  Retrieves whether this database supports only data manipulation statements within a transaction.
public boolean supportsDifferentTableCorrelationNames () throws SQLException
  Retrieves whether, when table correlation names are supported, they are restricted to being different from the names of the tables.
public boolean supportsExpressionsInOrderBy () throws SQLException
  Retrieves whether this database supports expressions in ORDER BY lists.
public boolean supportsExtendedSQLGrammar () throws SQLException
  Retrieves whether this database supports the ODBC Extended SQL grammar.
public boolean supportsFullOuterJoins () throws SQLException
  Retrieves whether this database supports full nested outer joins.
public boolean supportsGetGeneratedKeys () throws SQLException
  Retrieves whether auto-generated keys can be retrieved after a statement has been executed
public boolean supportsGroupBy () throws SQLException
  Retrieves whether this database supports some form of GROUP BY clause.
public boolean supportsGroupByBeyondSelect () throws SQLException
  Retrieves whether this database supports using columns not included in the SELECT statement in a GROUP BY clause provided that all of the columns in the SELECT statement are included in the GROUP BY clause.
public boolean supportsGroupByUnrelated () throws SQLException
  Retrieves whether this database supports using a column that is not in the SELECT statement in a GROUP BY clause.
public boolean supportsIntegrityEnhancementFacility () throws SQLException
  Retrieves whether this database supports the SQL Integrity Enhancement Facility.
public boolean supportsLikeEscapeClause () throws SQLException
  Retrieves whether this database supports specifying a LIKE escape clause.
public boolean supportsLimitedOuterJoins () throws SQLException
  Retrieves whether this database provides limited support for outer joins.
public boolean supportsMinimumSQLGrammar () throws SQLException
  Retrieves whether this database supports the ODBC Minimum SQL grammar.
public boolean supportsMixedCaseIdentifiers () throws SQLException
  Retrieves whether this database treats mixed case unquoted SQL identifiers as case sensitive and as a result stores them in mixed case.
public boolean supportsMixedCaseQuotedIdentifiers () throws SQLException
  Retrieves whether this database treats mixed case quoted SQL identifiers as case sensitive and as a result stores them in mixed case.
public boolean supportsMultipleOpenResults () throws SQLException
  Retrieves whether it is possible to have multiple ResultSet objects returned from a CallableStatement object simultaneously.
public boolean supportsMultipleResultSets () throws SQLException
  Retrieves whether this database supports getting multiple ResultSet objects from a single call to the method execute.
public boolean supportsMultipleTransactions () throws SQLException
  Retrieves whether this database allows having multiple transactions open at once (on different connections).
public boolean supportsNamedParameters () throws SQLException
  Retrieves whether this database supports named parameters to callable statements.
public boolean supportsNonNullableColumns () throws SQLException
  Retrieves whether columns in this database may be defined as non-nullable.
public boolean supportsOpenCursorsAcrossCommit () throws SQLException
  Retrieves whether this database supports keeping cursors open across commits.
public boolean supportsOpenCursorsAcrossRollback () throws SQLException
  Retrieves whether this database supports keeping cursors open across rollbacks.
public boolean supportsOpenStatementsAcrossCommit () throws SQLException
  Retrieves whether this database supports keeping statements open across commits.
public boolean supportsOpenStatementsAcrossRollback () throws SQLException
  Retrieves whether this database supports keeping statements open across rollbacks.
public boolean supportsOrderByUnrelated () throws SQLException
  Retrieves whether this database supports using a column that is not in the SELECT statement in an ORDER BY clause.
public boolean supportsOuterJoins () throws SQLException
  Retrieves whether this database supports some form of outer join.
public boolean supportsPositionedDelete () throws SQLException
  Retrieves whether this database supports positioned DELETE statements.
public boolean supportsPositionedUpdate () throws SQLException
  Retrieves whether this database supports positioned UPDATE statements.
public boolean supportsResultSetConcurrency (int type, int concurrency) throws SQLException
  Retrieves whether this database supports the given concurrency type in combination with the given result set type.
public boolean supportsResultSetHoldability (int holdability) throws SQLException
  Retrieves whether this database supports the given result set holdability.
public boolean supportsResultSetType (int type) throws SQLException
  Retrieves whether this database supports the given result set type.
public boolean supportsSavepoints () throws SQLException
  Retrieves whether this database supports savepoints.
public boolean supportsSchemasInDataManipulation () throws SQLException
  Retrieves whether a schema name can be used in a data manipulation statement.
public boolean supportsSchemasInIndexDefinitions () throws SQLException
  Retrieves whether a schema name can be used in an index definition statement.
public boolean supportsSchemasInPrivilegeDefinitions () throws SQLException
  Retrieves whether a schema name can be used in a privilege definition statement.
public boolean supportsSchemasInProcedureCalls () throws SQLException
  Retrieves whether a schema name can be used in a procedure call statement.
public boolean supportsSchemasInTableDefinitions () throws SQLException
  Retrieves whether a schema name can be used in a table definition statement.
public boolean supportsSelectForUpdate () throws SQLException
  Retrieves whether this database supports SELECT FOR UPDATE statements.
public boolean supportsStatementPooling () throws SQLException
  Retrieves whether this database supports statement pooling.
public boolean supportsStoredFunctionsUsingCallSyntax () throws SQLException
  Retrieves whether this database supports invoking user-defined or vendor functions using the stored procedure escape syntax.
public boolean supportsStoredProcedures () throws SQLException
  Retrieves whether this database supports stored procedure calls that use the stored procedure escape syntax.
public boolean supportsSubqueriesInComparisons () throws SQLException
  Retrieves whether this database supports subqueries in comparison expressions.
public boolean supportsSubqueriesInExists () throws SQLException
  Retrieves whether this database supports subqueries in EXISTS expressions.
public boolean supportsSubqueriesInIns () throws SQLException
  Retrieves whether this database supports subqueries in IN expressions.
public boolean supportsSubqueriesInQuantifieds () throws SQLException
  Retrieves whether this database supports subqueries in quantified expressions.
public boolean supportsTableCorrelationNames () throws SQLException
  Retrieves whether this database supports table correlation names.
public boolean supportsTransactionIsolationLevel (int level) throws SQLException
  Retrieves whether this database supports the given transaction isolation level.
public boolean supportsTransactions () throws SQLException
  Retrieves whether this database supports transactions.
public boolean supportsUnion () throws SQLException
  Retrieves whether this database supports SQL UNION.
public boolean supportsUnionAll () throws SQLException
  Retrieves whether this database supports SQL UNION ALL.
public boolean updatesAreDetected (int type) throws SQLException
  Retrieves whether or not a visible row update can be detected by calling the method ResultSet.rowUpdated.
public boolean usesLocalFilePerTable () throws SQLException
  Retrieves whether this database uses a file for each table.
public boolean usesLocalFiles () throws SQLException
  Retrieves whether this database stores tables in a local file.
Fields
publicfinalstatic short attributeNoNulls = "0"
  Indicates that NULL values might not be allowed.
publicfinalstatic short attributeNullable = "1"
  Indicates that NULL values are definitely allowed.
publicfinalstatic short attributeNullableUnknown = "2"
  Indicates that whether NULL values are allowed is not known.
publicfinalstatic int bestRowNotPseudo = "1"
  Indicates that the best row identifier is NOT a pseudo column.
publicfinalstatic int bestRowPseudo = "2"
  Indicates that the best row identifier is a pseudo column.
publicfinalstatic int bestRowSession = "2"
  Indicates that the scope of the best row identifier is the remainder of the current session.
publicfinalstatic int bestRowTemporary = "0"
  Indicates that the scope of the best row identifier is very temporary, lasting only while the row is being used.
publicfinalstatic int bestRowTransaction = "1"
  Indicates that the scope of the best row identifier is the remainder of the current transaction.
publicfinalstatic int bestRowUnknown = "0"
  Indicates that the best row identifier may or may not be a pseudo column.
publicfinalstatic int columnNoNulls = "0"
  Indicates that the column might not allow NULL values.
publicfinalstatic int columnNullable = "1"
  Indicates that the column definitely allows NULL values.
publicfinalstatic int columnNullableUnknown = "2"
  Indicates that the nullability of columns is unknown.
publicfinalstatic int functionColumnIn = "1"
  Indicates that the parameter or column is an IN parameter.
publicfinalstatic int functionColumnInOut = "2"
  Indicates that the parameter or column is an INOUT parameter.
publicfinalstatic int functionColumnOut = "3"
  Indicates that the parameter or column is an OUT parameter.
publicfinalstatic int functionColumnResult = "5"
  Indicates that the parameter or column is a column in a result set.
publicfinalstatic int functionColumnUnknown = "0"
  Indicates that type of the parameter or column is unknown.
publicfinalstatic int functionNoNulls = "0"
  Indicates that NULL values are not allowed.
publicfinalstatic int functionNoTable = "1"
  Indicates that the function does not return a table.
publicfinalstatic int functionNullable = "1"
  Indicates that NULL values are allowed.
publicfinalstatic int functionNullableUnknown = "2"
  Indicates that whether NULL values are allowed is unknown.
publicfinalstatic int functionResultUnknown = "0"
  Indicates that it is not known whether the function returns a result or a table.
publicfinalstatic int functionReturn = "4"
  Indicates that the parameter or column is a return value.
publicfinalstatic int functionReturnsTable = "2"
  Indicates that the function returns a table.
publicfinalstatic int importedKeyCascade = "0"
  For the column UPDATE_RULE, indicates that when the primary key is updated, the foreign key (imported key) is changed to agree with it.
publicfinalstatic int importedKeyInitiallyDeferred = "5"
  Indicates deferrability.
publicfinalstatic int importedKeyInitiallyImmediate = "6"
  Indicates deferrability.
publicfinalstatic int importedKeyNoAction = "3"
  For the columns UPDATE_RULE and DELETE_RULE, indicates that if the primary key has been imported, it cannot be updated or deleted.
publicfinalstatic int importedKeyNotDeferrable = "7"
  Indicates deferrability.
publicfinalstatic int importedKeyRestrict = "1"
  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.
publicfinalstatic int importedKeySetDefault = "4"
  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.
publicfinalstatic int importedKeySetNull = "2"
  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.
publicfinalstatic int procedureColumnIn = "1"
  Indicates that the column stores IN parameters.
publicfinalstatic int procedureColumnInOut = "2"
  Indicates that the column stores INOUT parameters.
publicfinalstatic int procedureColumnOut = "4"
  Indicates that the column stores OUT parameters.
publicfinalstatic int procedureColumnResult = "3"
  Indicates that the column stores results.
publicfinalstatic int procedureColumnReturn = "5"
  Indicates that the column stores return values.
publicfinalstatic int procedureColumnUnknown = "0"
  Indicates that type of the column is unknown.
publicfinalstatic int procedureNoNulls = "0"
  Indicates that NULL values are not allowed.
publicfinalstatic int procedureNoResult = "1"
  Indicates that the procedure does not return a result.
publicfinalstatic int procedureNullable = "1"
  Indicates that NULL values are allowed.
publicfinalstatic int procedureNullableUnknown = "2"
  Indicates that whether NULL values are allowed is unknown.
publicfinalstatic int procedureResultUnknown = "0"
  Indicates that it is not known whether the procedure returns a result.
publicfinalstatic int procedureReturnsResult = "2"
  Indicates that the procedure returns a result.
publicfinalstatic int sqlStateSQL = "2"
  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.
publicfinalstatic int sqlStateSQL99 = "2"
  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.
publicfinalstatic int sqlStateXOpen = "1"
  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.
publicfinalstatic short tableIndexClustered = "1"
  Indicates that this table index is a clustered index.
publicfinalstatic short tableIndexHashed = "2"
  Indicates that this table index is a hashed index.
publicfinalstatic short tableIndexOther = "3"
  Indicates that this table index is not a clustered index, a hashed index, or table statistics; it is something other than these.
publicfinalstatic short tableIndexStatistic = "0"
  Indicates that this column contains table statistics that are returned in conjunction with a table's index descriptions.
publicfinalstatic int typeNoNulls = "0"
  Indicates that a NULL value is NOT allowed for this data type.
publicfinalstatic int typeNullable = "1"
  Indicates that a NULL value is allowed for this data type.
publicfinalstatic int typeNullableUnknown = "2"
  Indicates that it is not known whether a NULL value is allowed for this data type.
publicfinalstatic int typePredBasic = "2"
  Indicates that the data type can be only be used in WHERE search clauses that do not use LIKE predicates.
publicfinalstatic int typePredChar = "1"
  Indicates that the data type can be only be used in WHERE search clauses that use LIKE predicates.
publicfinalstatic int typePredNone = "0"
  Indicates that WHERE search clauses are not supported for this type.
publicfinalstatic int typeSearchable = "3"
  Indicates that all WHERE search clauses can be based on this type.
publicfinalstatic int versionColumnNotPseudo = "1"
  Indicates that this version column is NOT a pseudo column.
publicfinalstatic int versionColumnPseudo = "2"
  Indicates that this version column is a pseudo column.
publicfinalstatic int versionColumnUnknown = "0"
  Indicates that this version column may or may not be a pseudo column.
Generated By: JavaOnTracks Doclet 0.1.4     ©Thibaut Colar