DatabaseMetaData (Java Platform SE 8 ) (original) (raw)

Modifier and Type

Method

Description

boolean

[allProceduresAreCallable](../../java/sql/DatabaseMetaData.html#allProceduresAreCallable--)()

Retrieves whether the current user can call all the procedures returned by the method getProcedures.

boolean

[allTablesAreSelectable](../../java/sql/DatabaseMetaData.html#allTablesAreSelectable--)()

Retrieves whether the current user can use all the tables returned by the method getTables in a SELECT statement.

boolean

[autoCommitFailureClosesAllResultSets](../../java/sql/DatabaseMetaData.html#autoCommitFailureClosesAllResultSets--)()

Retrieves whether a SQLException while autoCommit is true indicates that all open ResultSets are closed, even ones that are holdable.

boolean

[dataDefinitionCausesTransactionCommit](../../java/sql/DatabaseMetaData.html#dataDefinitionCausesTransactionCommit--)()

Retrieves whether a data definition statement within a transaction forces the transaction to commit.

boolean

[dataDefinitionIgnoredInTransactions](../../java/sql/DatabaseMetaData.html#dataDefinitionIgnoredInTransactions--)()

Retrieves whether this database ignores a data definition statement within a transaction.

boolean

[deletesAreDetected](../../java/sql/DatabaseMetaData.html#deletesAreDetected-int-)(int type)

Retrieves whether or not a visible row delete can be detected by calling the method ResultSet.rowDeleted.

boolean

[doesMaxRowSizeIncludeBlobs](../../java/sql/DatabaseMetaData.html#doesMaxRowSizeIncludeBlobs--)()

Retrieves whether the return value for the methodgetMaxRowSize includes the SQL data typesLONGVARCHAR and LONGVARBINARY.

boolean

[generatedKeyAlwaysReturned](../../java/sql/DatabaseMetaData.html#generatedKeyAlwaysReturned--)()

Retrieves whether a generated key will always be returned if the column name(s) or index(es) specified for the auto generated key column(s) are valid and the statement succeeds.

[ResultSet](../../java/sql/ResultSet.html "interface in java.sql")

[getAttributes](../../java/sql/DatabaseMetaData.html#getAttributes-java.lang.String-java.lang.String-java.lang.String-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") catalog,[String](../../java/lang/String.html "class in java.lang") schemaPattern,[String](../../java/lang/String.html "class in java.lang") typeNamePattern,[String](../../java/lang/String.html "class in java.lang") attributeNamePattern)

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.

[ResultSet](../../java/sql/ResultSet.html "interface in java.sql")

[getBestRowIdentifier](../../java/sql/DatabaseMetaData.html#getBestRowIdentifier-java.lang.String-java.lang.String-java.lang.String-int-boolean-)([String](../../java/lang/String.html "class in java.lang") catalog,[String](../../java/lang/String.html "class in java.lang") schema,[String](../../java/lang/String.html "class in java.lang") table, int scope, boolean nullable)

Retrieves a description of a table's optimal set of columns that uniquely identifies a row.

[ResultSet](../../java/sql/ResultSet.html "interface in java.sql")

[getCatalogs](../../java/sql/DatabaseMetaData.html#getCatalogs--)()

Retrieves the catalog names available in this database.

[String](../../java/lang/String.html "class in java.lang")

[getCatalogSeparator](../../java/sql/DatabaseMetaData.html#getCatalogSeparator--)()

Retrieves the String that this database uses as the separator between a catalog and table name.

[String](../../java/lang/String.html "class in java.lang")

[getCatalogTerm](../../java/sql/DatabaseMetaData.html#getCatalogTerm--)()

Retrieves the database vendor's preferred term for "catalog".

[ResultSet](../../java/sql/ResultSet.html "interface in java.sql")

[getClientInfoProperties](../../java/sql/DatabaseMetaData.html#getClientInfoProperties--)()

Retrieves a list of the client info properties that the driver supports.

[ResultSet](../../java/sql/ResultSet.html "interface in java.sql")

[getColumnPrivileges](../../java/sql/DatabaseMetaData.html#getColumnPrivileges-java.lang.String-java.lang.String-java.lang.String-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") catalog,[String](../../java/lang/String.html "class in java.lang") schema,[String](../../java/lang/String.html "class in java.lang") table,[String](../../java/lang/String.html "class in java.lang") columnNamePattern)

Retrieves a description of the access rights for a table's columns.

[ResultSet](../../java/sql/ResultSet.html "interface in java.sql")

[getColumns](../../java/sql/DatabaseMetaData.html#getColumns-java.lang.String-java.lang.String-java.lang.String-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") catalog,[String](../../java/lang/String.html "class in java.lang") schemaPattern,[String](../../java/lang/String.html "class in java.lang") tableNamePattern,[String](../../java/lang/String.html "class in java.lang") columnNamePattern)

Retrieves a description of table columns available in the specified catalog.

[Connection](../../java/sql/Connection.html "interface in java.sql")

[getConnection](../../java/sql/DatabaseMetaData.html#getConnection--)()

Retrieves the connection that produced this metadata object.

[ResultSet](../../java/sql/ResultSet.html "interface in java.sql")

[getCrossReference](../../java/sql/DatabaseMetaData.html#getCrossReference-java.lang.String-java.lang.String-java.lang.String-java.lang.String-java.lang.String-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") parentCatalog,[String](../../java/lang/String.html "class in java.lang") parentSchema,[String](../../java/lang/String.html "class in java.lang") parentTable,[String](../../java/lang/String.html "class in java.lang") foreignCatalog,[String](../../java/lang/String.html "class in java.lang") foreignSchema,[String](../../java/lang/String.html "class in java.lang") foreignTable)

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

int

[getDatabaseMajorVersion](../../java/sql/DatabaseMetaData.html#getDatabaseMajorVersion--)()

Retrieves the major version number of the underlying database.

int

[getDatabaseMinorVersion](../../java/sql/DatabaseMetaData.html#getDatabaseMinorVersion--)()

Retrieves the minor version number of the underlying database.

[String](../../java/lang/String.html "class in java.lang")

[getDatabaseProductName](../../java/sql/DatabaseMetaData.html#getDatabaseProductName--)()

Retrieves the name of this database product.

[String](../../java/lang/String.html "class in java.lang")

[getDatabaseProductVersion](../../java/sql/DatabaseMetaData.html#getDatabaseProductVersion--)()

Retrieves the version number of this database product.

int

[getDefaultTransactionIsolation](../../java/sql/DatabaseMetaData.html#getDefaultTransactionIsolation--)()

Retrieves this database's default transaction isolation level.

int

[getDriverMajorVersion](../../java/sql/DatabaseMetaData.html#getDriverMajorVersion--)()

Retrieves this JDBC driver's major version number.

int

[getDriverMinorVersion](../../java/sql/DatabaseMetaData.html#getDriverMinorVersion--)()

Retrieves this JDBC driver's minor version number.

[String](../../java/lang/String.html "class in java.lang")

[getDriverName](../../java/sql/DatabaseMetaData.html#getDriverName--)()

Retrieves the name of this JDBC driver.

[String](../../java/lang/String.html "class in java.lang")

[getDriverVersion](../../java/sql/DatabaseMetaData.html#getDriverVersion--)()

Retrieves the version number of this JDBC driver as a String.

[ResultSet](../../java/sql/ResultSet.html "interface in java.sql")

[getExportedKeys](../../java/sql/DatabaseMetaData.html#getExportedKeys-java.lang.String-java.lang.String-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") catalog,[String](../../java/lang/String.html "class in java.lang") schema,[String](../../java/lang/String.html "class in java.lang") table)

Retrieves a description of the foreign key columns that reference the given table's primary key columns (the foreign keys exported by a table).

[String](../../java/lang/String.html "class in java.lang")

[getExtraNameCharacters](../../java/sql/DatabaseMetaData.html#getExtraNameCharacters--)()

Retrieves all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _).

[ResultSet](../../java/sql/ResultSet.html "interface in java.sql")

[getFunctionColumns](../../java/sql/DatabaseMetaData.html#getFunctionColumns-java.lang.String-java.lang.String-java.lang.String-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") catalog,[String](../../java/lang/String.html "class in java.lang") schemaPattern,[String](../../java/lang/String.html "class in java.lang") functionNamePattern,[String](../../java/lang/String.html "class in java.lang") columnNamePattern)

Retrieves a description of the given catalog's system or user function parameters and return type.

[ResultSet](../../java/sql/ResultSet.html "interface in java.sql")

[getFunctions](../../java/sql/DatabaseMetaData.html#getFunctions-java.lang.String-java.lang.String-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") catalog,[String](../../java/lang/String.html "class in java.lang") schemaPattern,[String](../../java/lang/String.html "class in java.lang") functionNamePattern)

Retrieves a description of the system and user functions available in the given catalog.

[String](../../java/lang/String.html "class in java.lang")

[getIdentifierQuoteString](../../java/sql/DatabaseMetaData.html#getIdentifierQuoteString--)()

Retrieves the string used to quote SQL identifiers.

[ResultSet](../../java/sql/ResultSet.html "interface in java.sql")

[getImportedKeys](../../java/sql/DatabaseMetaData.html#getImportedKeys-java.lang.String-java.lang.String-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") catalog,[String](../../java/lang/String.html "class in java.lang") schema,[String](../../java/lang/String.html "class in java.lang") table)

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

[ResultSet](../../java/sql/ResultSet.html "interface in java.sql")

[getIndexInfo](../../java/sql/DatabaseMetaData.html#getIndexInfo-java.lang.String-java.lang.String-java.lang.String-boolean-boolean-)([String](../../java/lang/String.html "class in java.lang") catalog,[String](../../java/lang/String.html "class in java.lang") schema,[String](../../java/lang/String.html "class in java.lang") table, boolean unique, boolean approximate)

Retrieves a description of the given table's indices and statistics.

int

[getJDBCMajorVersion](../../java/sql/DatabaseMetaData.html#getJDBCMajorVersion--)()

Retrieves the major JDBC version number for this driver.

int

[getJDBCMinorVersion](../../java/sql/DatabaseMetaData.html#getJDBCMinorVersion--)()

Retrieves the minor JDBC version number for this driver.

int

[getMaxBinaryLiteralLength](../../java/sql/DatabaseMetaData.html#getMaxBinaryLiteralLength--)()

Retrieves the maximum number of hex characters this database allows in an inline binary literal.

int

[getMaxCatalogNameLength](../../java/sql/DatabaseMetaData.html#getMaxCatalogNameLength--)()

Retrieves the maximum number of characters that this database allows in a catalog name.

int

[getMaxCharLiteralLength](../../java/sql/DatabaseMetaData.html#getMaxCharLiteralLength--)()

Retrieves the maximum number of characters this database allows for a character literal.

int

[getMaxColumnNameLength](../../java/sql/DatabaseMetaData.html#getMaxColumnNameLength--)()

Retrieves the maximum number of characters this database allows for a column name.

int

[getMaxColumnsInGroupBy](../../java/sql/DatabaseMetaData.html#getMaxColumnsInGroupBy--)()

Retrieves the maximum number of columns this database allows in aGROUP BY clause.

int

[getMaxColumnsInIndex](../../java/sql/DatabaseMetaData.html#getMaxColumnsInIndex--)()

Retrieves the maximum number of columns this database allows in an index.

int

[getMaxColumnsInOrderBy](../../java/sql/DatabaseMetaData.html#getMaxColumnsInOrderBy--)()

Retrieves the maximum number of columns this database allows in anORDER BY clause.

int

[getMaxColumnsInSelect](../../java/sql/DatabaseMetaData.html#getMaxColumnsInSelect--)()

Retrieves the maximum number of columns this database allows in aSELECT list.

int

[getMaxColumnsInTable](../../java/sql/DatabaseMetaData.html#getMaxColumnsInTable--)()

Retrieves the maximum number of columns this database allows in a table.

int

[getMaxConnections](../../java/sql/DatabaseMetaData.html#getMaxConnections--)()

Retrieves the maximum number of concurrent connections to this database that are possible.

int

[getMaxCursorNameLength](../../java/sql/DatabaseMetaData.html#getMaxCursorNameLength--)()

Retrieves the maximum number of characters that this database allows in a cursor name.

int

[getMaxIndexLength](../../java/sql/DatabaseMetaData.html#getMaxIndexLength--)()

Retrieves the maximum number of bytes this database allows for an index, including all of the parts of the index.

default long

[getMaxLogicalLobSize](../../java/sql/DatabaseMetaData.html#getMaxLogicalLobSize--)()

Retrieves the maximum number of bytes this database allows for the logical size for a LOB.

int

[getMaxProcedureNameLength](../../java/sql/DatabaseMetaData.html#getMaxProcedureNameLength--)()

Retrieves the maximum number of characters that this database allows in a procedure name.

int

[getMaxRowSize](../../java/sql/DatabaseMetaData.html#getMaxRowSize--)()

Retrieves the maximum number of bytes this database allows in a single row.

int

[getMaxSchemaNameLength](../../java/sql/DatabaseMetaData.html#getMaxSchemaNameLength--)()

Retrieves the maximum number of characters that this database allows in a schema name.

int

[getMaxStatementLength](../../java/sql/DatabaseMetaData.html#getMaxStatementLength--)()

Retrieves the maximum number of characters this database allows in an SQL statement.

int

[getMaxStatements](../../java/sql/DatabaseMetaData.html#getMaxStatements--)()

Retrieves the maximum number of active statements to this database that can be open at the same time.

int

[getMaxTableNameLength](../../java/sql/DatabaseMetaData.html#getMaxTableNameLength--)()

Retrieves the maximum number of characters this database allows in a table name.

int

[getMaxTablesInSelect](../../java/sql/DatabaseMetaData.html#getMaxTablesInSelect--)()

Retrieves the maximum number of tables this database allows in aSELECT statement.

int

[getMaxUserNameLength](../../java/sql/DatabaseMetaData.html#getMaxUserNameLength--)()

Retrieves the maximum number of characters this database allows in a user name.

[String](../../java/lang/String.html "class in java.lang")

[getNumericFunctions](../../java/sql/DatabaseMetaData.html#getNumericFunctions--)()

Retrieves a comma-separated list of math functions available with this database.

[ResultSet](../../java/sql/ResultSet.html "interface in java.sql")

[getPrimaryKeys](../../java/sql/DatabaseMetaData.html#getPrimaryKeys-java.lang.String-java.lang.String-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") catalog,[String](../../java/lang/String.html "class in java.lang") schema,[String](../../java/lang/String.html "class in java.lang") table)

Retrieves a description of the given table's primary key columns.

[ResultSet](../../java/sql/ResultSet.html "interface in java.sql")

[getProcedureColumns](../../java/sql/DatabaseMetaData.html#getProcedureColumns-java.lang.String-java.lang.String-java.lang.String-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") catalog,[String](../../java/lang/String.html "class in java.lang") schemaPattern,[String](../../java/lang/String.html "class in java.lang") procedureNamePattern,[String](../../java/lang/String.html "class in java.lang") columnNamePattern)

Retrieves a description of the given catalog's stored procedure parameter and result columns.

[ResultSet](../../java/sql/ResultSet.html "interface in java.sql")

[getProcedures](../../java/sql/DatabaseMetaData.html#getProcedures-java.lang.String-java.lang.String-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") catalog,[String](../../java/lang/String.html "class in java.lang") schemaPattern,[String](../../java/lang/String.html "class in java.lang") procedureNamePattern)

Retrieves a description of the stored procedures available in the given catalog.

[String](../../java/lang/String.html "class in java.lang")

[getProcedureTerm](../../java/sql/DatabaseMetaData.html#getProcedureTerm--)()

Retrieves the database vendor's preferred term for "procedure".

[ResultSet](../../java/sql/ResultSet.html "interface in java.sql")

[getPseudoColumns](../../java/sql/DatabaseMetaData.html#getPseudoColumns-java.lang.String-java.lang.String-java.lang.String-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") catalog,[String](../../java/lang/String.html "class in java.lang") schemaPattern,[String](../../java/lang/String.html "class in java.lang") tableNamePattern,[String](../../java/lang/String.html "class in java.lang") columnNamePattern)

Retrieves a description of the pseudo or hidden columns available in a given table within the specified catalog and schema.

int

[getResultSetHoldability](../../java/sql/DatabaseMetaData.html#getResultSetHoldability--)()

Retrieves this database's default holdability for ResultSet objects.

[RowIdLifetime](../../java/sql/RowIdLifetime.html "enum in java.sql")

[getRowIdLifetime](../../java/sql/DatabaseMetaData.html#getRowIdLifetime--)()

Indicates whether or not this data source supports the SQL ROWID type, and if so the lifetime for which a RowId object remains valid.

[ResultSet](../../java/sql/ResultSet.html "interface in java.sql")

[getSchemas](../../java/sql/DatabaseMetaData.html#getSchemas--)()

Retrieves the schema names available in this database.

[ResultSet](../../java/sql/ResultSet.html "interface in java.sql")

[getSchemas](../../java/sql/DatabaseMetaData.html#getSchemas-java.lang.String-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") catalog,[String](../../java/lang/String.html "class in java.lang") schemaPattern)

Retrieves the schema names available in this database.

[String](../../java/lang/String.html "class in java.lang")

[getSchemaTerm](../../java/sql/DatabaseMetaData.html#getSchemaTerm--)()

Retrieves the database vendor's preferred term for "schema".

[String](../../java/lang/String.html "class in java.lang")

[getSearchStringEscape](../../java/sql/DatabaseMetaData.html#getSearchStringEscape--)()

Retrieves the string that can be used to escape wildcard characters.

[String](../../java/lang/String.html "class in java.lang")

[getSQLKeywords](../../java/sql/DatabaseMetaData.html#getSQLKeywords--)()

Retrieves a comma-separated list of all of this database's SQL keywords that are NOT also SQL:2003 keywords.

int

[getSQLStateType](../../java/sql/DatabaseMetaData.html#getSQLStateType--)()

Indicates whether the SQLSTATE returned by SQLException.getSQLState is X/Open (now known as Open Group) SQL CLI or SQL:2003.

[String](../../java/lang/String.html "class in java.lang")

[getStringFunctions](../../java/sql/DatabaseMetaData.html#getStringFunctions--)()

Retrieves a comma-separated list of string functions available with this database.

[ResultSet](../../java/sql/ResultSet.html "interface in java.sql")

[getSuperTables](../../java/sql/DatabaseMetaData.html#getSuperTables-java.lang.String-java.lang.String-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") catalog,[String](../../java/lang/String.html "class in java.lang") schemaPattern,[String](../../java/lang/String.html "class in java.lang") tableNamePattern)

Retrieves a description of the table hierarchies defined in a particular schema in this database.

[ResultSet](../../java/sql/ResultSet.html "interface in java.sql")

[getSuperTypes](../../java/sql/DatabaseMetaData.html#getSuperTypes-java.lang.String-java.lang.String-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") catalog,[String](../../java/lang/String.html "class in java.lang") schemaPattern,[String](../../java/lang/String.html "class in java.lang") typeNamePattern)

Retrieves a description of the user-defined type (UDT) hierarchies defined in a particular schema in this database.

[String](../../java/lang/String.html "class in java.lang")

[getSystemFunctions](../../java/sql/DatabaseMetaData.html#getSystemFunctions--)()

Retrieves a comma-separated list of system functions available with this database.

[ResultSet](../../java/sql/ResultSet.html "interface in java.sql")

[getTablePrivileges](../../java/sql/DatabaseMetaData.html#getTablePrivileges-java.lang.String-java.lang.String-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") catalog,[String](../../java/lang/String.html "class in java.lang") schemaPattern,[String](../../java/lang/String.html "class in java.lang") tableNamePattern)

Retrieves a description of the access rights for each table available in a catalog.

[ResultSet](../../java/sql/ResultSet.html "interface in java.sql")

[getTables](../../java/sql/DatabaseMetaData.html#getTables-java.lang.String-java.lang.String-java.lang.String-java.lang.String:A-)([String](../../java/lang/String.html "class in java.lang") catalog,[String](../../java/lang/String.html "class in java.lang") schemaPattern,[String](../../java/lang/String.html "class in java.lang") tableNamePattern,[String](../../java/lang/String.html "class in java.lang")[] types)

Retrieves a description of the tables available in the given catalog.

[ResultSet](../../java/sql/ResultSet.html "interface in java.sql")

[getTableTypes](../../java/sql/DatabaseMetaData.html#getTableTypes--)()

Retrieves the table types available in this database.

[String](../../java/lang/String.html "class in java.lang")

[getTimeDateFunctions](../../java/sql/DatabaseMetaData.html#getTimeDateFunctions--)()

Retrieves a comma-separated list of the time and date functions available with this database.

[ResultSet](../../java/sql/ResultSet.html "interface in java.sql")

[getTypeInfo](../../java/sql/DatabaseMetaData.html#getTypeInfo--)()

Retrieves a description of all the data types supported by this database.

[ResultSet](../../java/sql/ResultSet.html "interface in java.sql")

[getUDTs](../../java/sql/DatabaseMetaData.html#getUDTs-java.lang.String-java.lang.String-java.lang.String-int:A-)([String](../../java/lang/String.html "class in java.lang") catalog,[String](../../java/lang/String.html "class in java.lang") schemaPattern,[String](../../java/lang/String.html "class in java.lang") typeNamePattern, int[] types)

Retrieves a description of the user-defined types (UDTs) defined in a particular schema.

[String](../../java/lang/String.html "class in java.lang")

[getURL](../../java/sql/DatabaseMetaData.html#getURL--)()

Retrieves the URL for this DBMS.

[String](../../java/lang/String.html "class in java.lang")

[getUserName](../../java/sql/DatabaseMetaData.html#getUserName--)()

Retrieves the user name as known to this database.

[ResultSet](../../java/sql/ResultSet.html "interface in java.sql")

[getVersionColumns](../../java/sql/DatabaseMetaData.html#getVersionColumns-java.lang.String-java.lang.String-java.lang.String-)([String](../../java/lang/String.html "class in java.lang") catalog,[String](../../java/lang/String.html "class in java.lang") schema,[String](../../java/lang/String.html "class in java.lang") table)

Retrieves a description of a table's columns that are automatically updated when any value in a row is updated.

boolean

[insertsAreDetected](../../java/sql/DatabaseMetaData.html#insertsAreDetected-int-)(int type)

Retrieves whether or not a visible row insert can be detected by calling the method ResultSet.rowInserted.

boolean

[isCatalogAtStart](../../java/sql/DatabaseMetaData.html#isCatalogAtStart--)()

Retrieves whether a catalog appears at the start of a fully qualified table name.

boolean

[isReadOnly](../../java/sql/DatabaseMetaData.html#isReadOnly--)()

Retrieves whether this database is in read-only mode.

boolean

[locatorsUpdateCopy](../../java/sql/DatabaseMetaData.html#locatorsUpdateCopy--)()

Indicates whether updates made to a LOB are made on a copy or directly to the LOB.

boolean

[nullPlusNonNullIsNull](../../java/sql/DatabaseMetaData.html#nullPlusNonNullIsNull--)()

Retrieves whether this database supports concatenations betweenNULL and non-NULL values beingNULL.

boolean

[nullsAreSortedAtEnd](../../java/sql/DatabaseMetaData.html#nullsAreSortedAtEnd--)()

Retrieves whether NULL values are sorted at the end regardless of sort order.

boolean

[nullsAreSortedAtStart](../../java/sql/DatabaseMetaData.html#nullsAreSortedAtStart--)()

Retrieves whether NULL values are sorted at the start regardless of sort order.

boolean

[nullsAreSortedHigh](../../java/sql/DatabaseMetaData.html#nullsAreSortedHigh--)()

Retrieves whether NULL values are sorted high.

boolean

[nullsAreSortedLow](../../java/sql/DatabaseMetaData.html#nullsAreSortedLow--)()

Retrieves whether NULL values are sorted low.

boolean

[othersDeletesAreVisible](../../java/sql/DatabaseMetaData.html#othersDeletesAreVisible-int-)(int type)

Retrieves whether deletes made by others are visible.

boolean

[othersInsertsAreVisible](../../java/sql/DatabaseMetaData.html#othersInsertsAreVisible-int-)(int type)

Retrieves whether inserts made by others are visible.

boolean

[othersUpdatesAreVisible](../../java/sql/DatabaseMetaData.html#othersUpdatesAreVisible-int-)(int type)

Retrieves whether updates made by others are visible.

boolean

[ownDeletesAreVisible](../../java/sql/DatabaseMetaData.html#ownDeletesAreVisible-int-)(int type)

Retrieves whether a result set's own deletes are visible.

boolean

[ownInsertsAreVisible](../../java/sql/DatabaseMetaData.html#ownInsertsAreVisible-int-)(int type)

Retrieves whether a result set's own inserts are visible.

boolean

[ownUpdatesAreVisible](../../java/sql/DatabaseMetaData.html#ownUpdatesAreVisible-int-)(int type)

Retrieves whether for the given type of ResultSet object, the result set's own updates are visible.

boolean

[storesLowerCaseIdentifiers](../../java/sql/DatabaseMetaData.html#storesLowerCaseIdentifiers--)()

Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in lower case.

boolean

[storesLowerCaseQuotedIdentifiers](../../java/sql/DatabaseMetaData.html#storesLowerCaseQuotedIdentifiers--)()

Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in lower case.

boolean

[storesMixedCaseIdentifiers](../../java/sql/DatabaseMetaData.html#storesMixedCaseIdentifiers--)()

Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case.

boolean

[storesMixedCaseQuotedIdentifiers](../../java/sql/DatabaseMetaData.html#storesMixedCaseQuotedIdentifiers--)()

Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in mixed case.

boolean

[storesUpperCaseIdentifiers](../../java/sql/DatabaseMetaData.html#storesUpperCaseIdentifiers--)()

Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in upper case.

boolean

[storesUpperCaseQuotedIdentifiers](../../java/sql/DatabaseMetaData.html#storesUpperCaseQuotedIdentifiers--)()

Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in upper case.

boolean

[supportsAlterTableWithAddColumn](../../java/sql/DatabaseMetaData.html#supportsAlterTableWithAddColumn--)()

Retrieves whether this database supports ALTER TABLE with add column.

boolean

[supportsAlterTableWithDropColumn](../../java/sql/DatabaseMetaData.html#supportsAlterTableWithDropColumn--)()

Retrieves whether this database supports ALTER TABLE with drop column.

boolean

[supportsANSI92EntryLevelSQL](../../java/sql/DatabaseMetaData.html#supportsANSI92EntryLevelSQL--)()

Retrieves whether this database supports the ANSI92 entry level SQL grammar.

boolean

[supportsANSI92FullSQL](../../java/sql/DatabaseMetaData.html#supportsANSI92FullSQL--)()

Retrieves whether this database supports the ANSI92 full SQL grammar supported.

boolean

[supportsANSI92IntermediateSQL](../../java/sql/DatabaseMetaData.html#supportsANSI92IntermediateSQL--)()

Retrieves whether this database supports the ANSI92 intermediate SQL grammar supported.

boolean

[supportsBatchUpdates](../../java/sql/DatabaseMetaData.html#supportsBatchUpdates--)()

Retrieves whether this database supports batch updates.

boolean

[supportsCatalogsInDataManipulation](../../java/sql/DatabaseMetaData.html#supportsCatalogsInDataManipulation--)()

Retrieves whether a catalog name can be used in a data manipulation statement.

boolean

[supportsCatalogsInIndexDefinitions](../../java/sql/DatabaseMetaData.html#supportsCatalogsInIndexDefinitions--)()

Retrieves whether a catalog name can be used in an index definition statement.

boolean

[supportsCatalogsInPrivilegeDefinitions](../../java/sql/DatabaseMetaData.html#supportsCatalogsInPrivilegeDefinitions--)()

Retrieves whether a catalog name can be used in a privilege definition statement.

boolean

[supportsCatalogsInProcedureCalls](../../java/sql/DatabaseMetaData.html#supportsCatalogsInProcedureCalls--)()

Retrieves whether a catalog name can be used in a procedure call statement.

boolean

[supportsCatalogsInTableDefinitions](../../java/sql/DatabaseMetaData.html#supportsCatalogsInTableDefinitions--)()

Retrieves whether a catalog name can be used in a table definition statement.

boolean

[supportsColumnAliasing](../../java/sql/DatabaseMetaData.html#supportsColumnAliasing--)()

Retrieves whether this database supports column aliasing.

boolean

[supportsConvert](../../java/sql/DatabaseMetaData.html#supportsConvert--)()

Retrieves whether this database supports the JDBC scalar functionCONVERT for the conversion of one JDBC type to another.

boolean

[supportsConvert](../../java/sql/DatabaseMetaData.html#supportsConvert-int-int-)(int fromType, int toType)

Retrieves whether this database supports the JDBC scalar functionCONVERT for conversions between the JDBC types fromType and toType.

boolean

[supportsCoreSQLGrammar](../../java/sql/DatabaseMetaData.html#supportsCoreSQLGrammar--)()

Retrieves whether this database supports the ODBC Core SQL grammar.

boolean

[supportsCorrelatedSubqueries](../../java/sql/DatabaseMetaData.html#supportsCorrelatedSubqueries--)()

Retrieves whether this database supports correlated subqueries.

boolean

[supportsDataDefinitionAndDataManipulationTransactions](../../java/sql/DatabaseMetaData.html#supportsDataDefinitionAndDataManipulationTransactions--)()

Retrieves whether this database supports both data definition and data manipulation statements within a transaction.

boolean

[supportsDataManipulationTransactionsOnly](../../java/sql/DatabaseMetaData.html#supportsDataManipulationTransactionsOnly--)()

Retrieves whether this database supports only data manipulation statements within a transaction.

boolean

[supportsDifferentTableCorrelationNames](../../java/sql/DatabaseMetaData.html#supportsDifferentTableCorrelationNames--)()

Retrieves whether, when table correlation names are supported, they are restricted to being different from the names of the tables.

boolean

[supportsExpressionsInOrderBy](../../java/sql/DatabaseMetaData.html#supportsExpressionsInOrderBy--)()

Retrieves whether this database supports expressions inORDER BY lists.

boolean

[supportsExtendedSQLGrammar](../../java/sql/DatabaseMetaData.html#supportsExtendedSQLGrammar--)()

Retrieves whether this database supports the ODBC Extended SQL grammar.

boolean

[supportsFullOuterJoins](../../java/sql/DatabaseMetaData.html#supportsFullOuterJoins--)()

Retrieves whether this database supports full nested outer joins.

boolean

[supportsGetGeneratedKeys](../../java/sql/DatabaseMetaData.html#supportsGetGeneratedKeys--)()

Retrieves whether auto-generated keys can be retrieved after a statement has been executed

boolean

[supportsGroupBy](../../java/sql/DatabaseMetaData.html#supportsGroupBy--)()

Retrieves whether this database supports some form ofGROUP BY clause.

boolean

[supportsGroupByBeyondSelect](../../java/sql/DatabaseMetaData.html#supportsGroupByBeyondSelect--)()

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.

boolean

[supportsGroupByUnrelated](../../java/sql/DatabaseMetaData.html#supportsGroupByUnrelated--)()

Retrieves whether this database supports using a column that is not in the SELECT statement in aGROUP BY clause.

boolean

[supportsIntegrityEnhancementFacility](../../java/sql/DatabaseMetaData.html#supportsIntegrityEnhancementFacility--)()

Retrieves whether this database supports the SQL Integrity Enhancement Facility.

boolean

[supportsLikeEscapeClause](../../java/sql/DatabaseMetaData.html#supportsLikeEscapeClause--)()

Retrieves whether this database supports specifying aLIKE escape clause.

boolean

[supportsLimitedOuterJoins](../../java/sql/DatabaseMetaData.html#supportsLimitedOuterJoins--)()

Retrieves whether this database provides limited support for outer joins.

boolean

[supportsMinimumSQLGrammar](../../java/sql/DatabaseMetaData.html#supportsMinimumSQLGrammar--)()

Retrieves whether this database supports the ODBC Minimum SQL grammar.

boolean

[supportsMixedCaseIdentifiers](../../java/sql/DatabaseMetaData.html#supportsMixedCaseIdentifiers--)()

Retrieves whether this database treats mixed case unquoted SQL identifiers as case sensitive and as a result stores them in mixed case.

boolean

[supportsMixedCaseQuotedIdentifiers](../../java/sql/DatabaseMetaData.html#supportsMixedCaseQuotedIdentifiers--)()

Retrieves whether this database treats mixed case quoted SQL identifiers as case sensitive and as a result stores them in mixed case.

boolean

[supportsMultipleOpenResults](../../java/sql/DatabaseMetaData.html#supportsMultipleOpenResults--)()

Retrieves whether it is possible to have multiple ResultSet objects returned from a CallableStatement object simultaneously.

boolean

[supportsMultipleResultSets](../../java/sql/DatabaseMetaData.html#supportsMultipleResultSets--)()

Retrieves whether this database supports getting multipleResultSet objects from a single call to the method execute.

boolean

[supportsMultipleTransactions](../../java/sql/DatabaseMetaData.html#supportsMultipleTransactions--)()

Retrieves whether this database allows having multiple transactions open at once (on different connections).

boolean

[supportsNamedParameters](../../java/sql/DatabaseMetaData.html#supportsNamedParameters--)()

Retrieves whether this database supports named parameters to callable statements.

boolean

[supportsNonNullableColumns](../../java/sql/DatabaseMetaData.html#supportsNonNullableColumns--)()

Retrieves whether columns in this database may be defined as non-nullable.

boolean

[supportsOpenCursorsAcrossCommit](../../java/sql/DatabaseMetaData.html#supportsOpenCursorsAcrossCommit--)()

Retrieves whether this database supports keeping cursors open across commits.

boolean

[supportsOpenCursorsAcrossRollback](../../java/sql/DatabaseMetaData.html#supportsOpenCursorsAcrossRollback--)()

Retrieves whether this database supports keeping cursors open across rollbacks.

boolean

[supportsOpenStatementsAcrossCommit](../../java/sql/DatabaseMetaData.html#supportsOpenStatementsAcrossCommit--)()

Retrieves whether this database supports keeping statements open across commits.

boolean

[supportsOpenStatementsAcrossRollback](../../java/sql/DatabaseMetaData.html#supportsOpenStatementsAcrossRollback--)()

Retrieves whether this database supports keeping statements open across rollbacks.

boolean

[supportsOrderByUnrelated](../../java/sql/DatabaseMetaData.html#supportsOrderByUnrelated--)()

Retrieves whether this database supports using a column that is not in the SELECT statement in anORDER BY clause.

boolean

[supportsOuterJoins](../../java/sql/DatabaseMetaData.html#supportsOuterJoins--)()

Retrieves whether this database supports some form of outer join.

boolean

[supportsPositionedDelete](../../java/sql/DatabaseMetaData.html#supportsPositionedDelete--)()

Retrieves whether this database supports positioned DELETE statements.

boolean

[supportsPositionedUpdate](../../java/sql/DatabaseMetaData.html#supportsPositionedUpdate--)()

Retrieves whether this database supports positioned UPDATE statements.

default boolean

[supportsRefCursors](../../java/sql/DatabaseMetaData.html#supportsRefCursors--)()

Retrieves whether this database supports REF CURSOR.

boolean

[supportsResultSetConcurrency](../../java/sql/DatabaseMetaData.html#supportsResultSetConcurrency-int-int-)(int type, int concurrency)

Retrieves whether this database supports the given concurrency type in combination with the given result set type.

boolean

[supportsResultSetHoldability](../../java/sql/DatabaseMetaData.html#supportsResultSetHoldability-int-)(int holdability)

Retrieves whether this database supports the given result set holdability.

boolean

[supportsResultSetType](../../java/sql/DatabaseMetaData.html#supportsResultSetType-int-)(int type)

Retrieves whether this database supports the given result set type.

boolean

[supportsSavepoints](../../java/sql/DatabaseMetaData.html#supportsSavepoints--)()

Retrieves whether this database supports savepoints.

boolean

[supportsSchemasInDataManipulation](../../java/sql/DatabaseMetaData.html#supportsSchemasInDataManipulation--)()

Retrieves whether a schema name can be used in a data manipulation statement.

boolean

[supportsSchemasInIndexDefinitions](../../java/sql/DatabaseMetaData.html#supportsSchemasInIndexDefinitions--)()

Retrieves whether a schema name can be used in an index definition statement.

boolean

[supportsSchemasInPrivilegeDefinitions](../../java/sql/DatabaseMetaData.html#supportsSchemasInPrivilegeDefinitions--)()

Retrieves whether a schema name can be used in a privilege definition statement.

boolean

[supportsSchemasInProcedureCalls](../../java/sql/DatabaseMetaData.html#supportsSchemasInProcedureCalls--)()

Retrieves whether a schema name can be used in a procedure call statement.

boolean

[supportsSchemasInTableDefinitions](../../java/sql/DatabaseMetaData.html#supportsSchemasInTableDefinitions--)()

Retrieves whether a schema name can be used in a table definition statement.

boolean

[supportsSelectForUpdate](../../java/sql/DatabaseMetaData.html#supportsSelectForUpdate--)()

Retrieves whether this database supports SELECT FOR UPDATE statements.

boolean

[supportsStatementPooling](../../java/sql/DatabaseMetaData.html#supportsStatementPooling--)()

Retrieves whether this database supports statement pooling.

boolean

[supportsStoredFunctionsUsingCallSyntax](../../java/sql/DatabaseMetaData.html#supportsStoredFunctionsUsingCallSyntax--)()

Retrieves whether this database supports invoking user-defined or vendor functions using the stored procedure escape syntax.

boolean

[supportsStoredProcedures](../../java/sql/DatabaseMetaData.html#supportsStoredProcedures--)()

Retrieves whether this database supports stored procedure calls that use the stored procedure escape syntax.

boolean

[supportsSubqueriesInComparisons](../../java/sql/DatabaseMetaData.html#supportsSubqueriesInComparisons--)()

Retrieves whether this database supports subqueries in comparison expressions.

boolean

[supportsSubqueriesInExists](../../java/sql/DatabaseMetaData.html#supportsSubqueriesInExists--)()

Retrieves whether this database supports subqueries inEXISTS expressions.

boolean

[supportsSubqueriesInIns](../../java/sql/DatabaseMetaData.html#supportsSubqueriesInIns--)()

Retrieves whether this database supports subqueries inIN expressions.

boolean

[supportsSubqueriesInQuantifieds](../../java/sql/DatabaseMetaData.html#supportsSubqueriesInQuantifieds--)()

Retrieves whether this database supports subqueries in quantified expressions.

boolean

[supportsTableCorrelationNames](../../java/sql/DatabaseMetaData.html#supportsTableCorrelationNames--)()

Retrieves whether this database supports table correlation names.

boolean

[supportsTransactionIsolationLevel](../../java/sql/DatabaseMetaData.html#supportsTransactionIsolationLevel-int-)(int level)

Retrieves whether this database supports the given transaction isolation level.

boolean

[supportsTransactions](../../java/sql/DatabaseMetaData.html#supportsTransactions--)()

Retrieves whether this database supports transactions.

boolean

[supportsUnion](../../java/sql/DatabaseMetaData.html#supportsUnion--)()

Retrieves whether this database supports SQL UNION.

boolean

[supportsUnionAll](../../java/sql/DatabaseMetaData.html#supportsUnionAll--)()

Retrieves whether this database supports SQL UNION ALL.

boolean

[updatesAreDetected](../../java/sql/DatabaseMetaData.html#updatesAreDetected-int-)(int type)

Retrieves whether or not a visible row update can be detected by calling the method ResultSet.rowUpdated.

boolean

[usesLocalFilePerTable](../../java/sql/DatabaseMetaData.html#usesLocalFilePerTable--)()

Retrieves whether this database uses a file for each table.

boolean

[usesLocalFiles](../../java/sql/DatabaseMetaData.html#usesLocalFiles--)()

Retrieves whether this database stores tables in a local file.