DatabaseMetaData Methods Version Introduced Supported Comments
boolean autoCommitFailureClosesAllResultSets() 4.0 Yes  
boolean allProceduresAreCallable() 1.0 Yes  
boolean allTablesAreSelectable() 1.0 Yes  
boolean dataDefinitionCausesTransactionCommit() 1.0 Yes  
boolean dataDefinitionIgnoredInTransactions() 1.0 Yes  
boolean deletesAreDetected(int) 2.0 Core Yes  
boolean doesMaxRowSizeIncludeBlobs() 1.0 Yes Not supported by the SQL Server and Sybase drivers.
getAttributes(String, String, String, String) 3.0 Yes The Oracle driver may return results.

All other drivers return an empty result set.
ResultSet getBestRowIdentifier(String, String, String, int, boolean) 1.0 Yes
ResultSet getCatalogs() 1.0 Yes
String getCatalogSeparator() 1.0 Yes  
String getCatalogTerm() 1.0 Yes  
String getClientInfoProperties() 4.0 Yes The Autonomous REST Connector and the drivers for Aha!, Apache Cassandra, Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, HubSpot, Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, Salesforce, SAP HANA, SAP S/4HANA, SharePoint, Snowflake, and TeamCity do not support storing or retrieving client information.
ResultSet getColumnPrivileges(String, String, String, String) 1.0 Yes Not supported by the drivers for Apache Hive, Apache Spark SQL, Apache Impala, Oracle Eloqua, and Oracle Sales Cloud.
ResultSet getColumns(String, String, String, String) 1.0 Yes  
Connection getConnection() 2.0 Core Yes  
ResultSet getCrossReference(String, String, String, String, String, String) 1.0 Yes
ResultSet getFunctions() 4.0 Yes The Autonomous REST Connector and the drivers for Aha!, Apache Cassandra, Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, HubSpot, Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, Salesforce, SAP HANA, SAP S/4HANA, SharePoint, and TeamCity return an empty result set.

Not supported by the drivers for Apache Hive, Apache Spark SQL, or Apache Impala.
ResultSet getFunctionColumns() 4.0 Yes The Autonomous REST Connector and the drivers for Aha!, Apache Cassandra, Dynamics 365, GitHub, Google Analytics 4, Google BigQuery, HubSpot, Jira, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, Salesforce, SAP HANA, SAP S/4HANA, SharePoint, and TeamCity return an empty result set.

Not supported by the drivers for Apache Hive, Apache Spark SQL, or Apache Impala.
int getDatabaseMajorVersion() 3.0 Yes  
int getDatabaseMinorVersion() 3.0 Yes  
String getDatabaseProductName() 1.0 Yes  
String getDatabaseProductVersion() 1.0 Yes  
int getDefaultTransactionIsolation() 1.0 Yes  
int getDriverMajorVersion() 1.0 Yes  
int getDriverMinorVersion() 1.0 Yes  
String getDriverName() 1.0 Yes  
String getDriverVersion() 1.0 Yes  
ResultSet getExportedKeys(String, String, String) 1.0 Yes  
String getExtraNameCharacters() 1.0 Yes  
String getIdentifierQuoteString() 1.0 Yes  
ResultSet getImportedKeys(String, String, String) 1.0 Yes  
ResultSet getIndexInfo(String, String, String, boolean, boolean) 1.0 Yes  
int getJDBCMajorVersion() 3.0 Yes  
int getJDBCMinorVersion() 3.0 Yes  
int getMaxBinaryLiteralLength() 1.0 Yes  
int getMaxCatalogNameLength() 1.0 Yes  
int getMaxCharLiteralLength() 1.0 Yes  
int getMaxColumnNameLength() 1.0 Yes  
int getMaxColumnsInGroupBy() 1.0 Yes  
int getMaxColumnsInIndex() 1.0 Yes  
int getMaxColumnsInOrderBy() 1.0 Yes  
int getMaxColumnsInSelect() 1.0 Yes  
int getMaxColumnsInTable() 1.0 Yes  
int getMaxConnections() 1.0 Yes  
int getMaxCursorNameLength() 1.0 Yes  
int getMaxIndexLength() 1.0 Yes  
int getMaxProcedureNameLength() 1.0 Yes  
int getMaxRowSize() 1.0 Yes  
int getMaxSchemaNameLength() 1.0 Yes  
int getMaxStatementLength() 1.0 Yes  
int getMaxStatements() 1.0 Yes  
int getMaxTableNameLength() 1.0 Yes  
int getMaxTablesInSelect() 1.0 Yes  
int getMaxUserNameLength() 1.0 Yes  
String getNumericFunctions() 1.0 Yes  
ResultSet getPrimaryKeys(String, String, String) 1.0 Yes  
ResultSet getProcedureColumns(String, String, String, String) 1.0 Yes For the Autonomous REST Connector and the drivers for Aha!, Dynamics 365, GitHub, Google Analytics 4, HubSpot, Jira, Oracle Service Cloud, Salesforce, SAP HANA, SAP S/4HANA, SharePoint, and TeamCity, SchemaName and ProcedureName must be explicit values; they cannot be patterns.

The drivers for Apache Cassandra and MongoDB return an empty result set.

Not supported for the drivers for Apache Hive, Apache Spark SQL, or Apache Impala.
ResultSet getProcedures(String, String, String) 1.0 Yes The drivers for Apache Cassandra, MongoDB, Oracle Eloqua, and Oracle Sales Cloud return an empty result set.

Not supported for the drivers for Apache Hive, Apache Spark SQL, or Apache Impala.
String getProcedureTerm() 1.0 Yes  
int getResultSetHoldability() 3.0 Yes  
ResultSet getSchemas() 1.0 Yes  
ResultSet getSchemas(catalog, pattern) 4.0 Yes  
String getSchemaTerm() 1.0 Yes  
String getSearchStringEscape() 1.0 Yes  
String getSQLKeywords() 1.0 Yes  
int getSQLStateType() 3.0 Yes  
String getStringFunctions() 1.0 Yes  
ResultSet getSuperTables(String, String, String) 3.0 Yes Returns an empty result set.
ResultSet getSuperTypes(String, String, String) 3.0 Yes Returns an empty result set.
String getSystemFunctions() 1.0 Yes
ResultSet getTablePrivileges(String, String, String) 1.0 Yes Not supported for the drivers for Apache Hive, Apache Spark SQL, Apache Impala, Oracle Eloqua, and Oracle Sales Cloud.
ResultSet getTables(String, String, String, String []) 1.0 Yes  
ResultSet getTableTypes() 1.0 Yes  
String getTimeDateFunctions() 1.0 Yes  
ResultSet getTypeInfo() 1.0 Yes  
ResultSet getUDTs(String, String, String, int []) 2.0 Core Yes Supported for Oracle only.
String getURL() 1.0 Yes  
String getUserName() 1.0 Yes  
ResultSet getVersionColumns(String, String, String) 1.0 Yes  
boolean insertsAreDetected(int) 2.0 Core Yes  
boolean isCatalogAtStart() 1.0 Yes  
boolean isReadOnly() 1.0 Yes  
boolean isWrapperFor(Class<?> iface) 4.0 Yes  
boolean locatorsUpdateCopy() 3.0 Yes  
boolean nullPlusNonNullIsNull() 1.0 Yes  
boolean nullsAreSortedAtEnd() 1.0 Yes  
boolean nullsAreSortedAtStart() 1.0 Yes  
boolean nullsAreSortedHigh() 1.0 Yes  
boolean nullsAreSortedLow() 1.0 Yes  
boolean othersDeletesAreVisible(int) 2.0 Core Yes  
boolean othersInsertsAreVisible(int) 2.0 Core Yes  
boolean othersUpdatesAreVisible(int) 2.0 Core Yes  
boolean ownDeletesAreVisible(int) 2.0 Core Yes  
boolean ownInsertsAreVisible(int) 2.0 Core Yes  
boolean ownUpdatesAreVisible(int) 2.0 Core Yes  
boolean storesLowerCaseIdentifiers() 1.0 Yes  
boolean storesLowerCaseQuotedIdentifiers() 1.0 Yes  
boolean storesMixedCaseIdentifiers() 1.0 Yes  
boolean storesMixedCaseQuotedIdentifiers() 1.0 Yes  
boolean storesUpperCaseIdentifiers() 1.0 Yes  
boolean storesUpperCaseQuotedIdentifiers() 1.0 Yes  
boolean supportsAlterTableWithAddColumn() 1.0 Yes  
boolean supportsAlterTableWithDropColumn() 1.0 Yes  
boolean supportsANSI92EntryLevelSQL() 1.0 Yes  
boolean supportsANSI92FullSQL() 1.0 Yes  
boolean supportsANSI92IntermediateSQL() 1.0 Yes  
boolean supportsBatchUpdates() 2.0 Core Yes  
boolean supportsCatalogsInDataManipulation() 1.0 Yes  
boolean supportsCatalogsInIndexDefinitions() 1.0 Yes  
boolean supportsCatalogsInPrivilegeDefinitions() 1.0 Yes  
boolean supportsCatalogsInProcedureCalls() 1.0 Yes  
boolean supportsCatalogsInTableDefinitions() 1.0 Yes  
boolean supportsColumnAliasing() 1.0 Yes  
boolean supportsConvert() 1.0 Yes  
boolean supportsConvert(int, int) 1.0 Yes  
boolean supportsCoreSQLGrammar() 1.0 Yes  
boolean supportsCorrelatedSubqueries() 1.0 Yes  
boolean supportsDataDefinitionAndData ManipulationTransactions() 1.0 Yes  
boolean supportsDataManipulationTransactionsOnly() 1.0 Yes  
boolean supportsDifferentTableCorrelationNames() 1.0 Yes  
boolean supportsExpressionsInOrderBy() 1.0 Yes  
boolean supportsExtendedSQLGrammar() 1.0 Yes  
boolean supportsFullOuterJoins() 1.0 Yes  
boolean supportsGetGeneratedKeys() 3.0 Yes  
boolean supportsGroupBy() 1.0 Yes  
boolean supportsGroupByBeyondSelect() 1.0 Yes  
boolean supportsGroupByUnrelated() 1.0 Yes  
boolean supportsIntegrityEnhancementFacility() 1.0 Yes  
boolean supportsLikeEscapeClause() 1.0 Yes  
boolean supportsLimitedOuterJoins() 1.0 Yes  
boolean supportsMinimumSQLGrammar() 1.0 Yes  
boolean supportsMixedCaseIdentifiers() 1.0 Yes  
boolean supportsMixedCaseQuotedIdentifiers() 1.0 Yes  
boolean supportsMultipleOpenResults() 3.0 Yes  
boolean supportsMultipleResultSets() 1.0 Yes  
boolean supportsMultipleTransactions() 1.0 Yes  
boolean supportsNamedParameters() 3.0 Yes  
boolean supportsNonNullableColumns() 1.0 Yes  
boolean supportsOpenCursorsAcrossCommit() 1.0 Yes  
boolean supportsOpenCursorsAcrossRollback() 1.0 Yes  
boolean supportsOpenStatementsAcrossCommit() 1.0 Yes  
boolean supportsOpenStatementsAcrossRollback() 1.0 Yes  
boolean supportsOrderByUnrelated() 1.0 Yes  
boolean supportsOuterJoins() 1.0 Yes  
boolean supportsPositionedDelete() 1.0 Yes  
boolean supportsPositionedUpdate() 1.0 Yes  
boolean supportsResultSetConcurrency(int, int) 2.0 Core Yes  
boolean supportsResultSetHoldability(int) 3.0 Yes  
boolean supportsResultSetType(int) 2.0 Core Yes  
boolean supportsSavePoints() 3.0 Yes  
boolean supportsSchemasInDataManipulation() 1.0 Yes  
boolean supportsSchemasInIndexDefinitions() 1.0 Yes  
boolean supportsSchemasInPrivilegeDefinitions() 1.0 Yes  
boolean supportsSchemasInProcedureCalls() 1.0 Yes  
boolean supportsSchemasInTableDefinitions() 1.0 Yes  
boolean supportsSelectForUpdate() 1.0 Yes  
boolean supportsStoredFunctionsUsingCallSyntax() 4.0 Yes  
boolean supportsStoredProcedures() 1.0 Yes  
boolean supportsSubqueriesInComparisons() 1.0 Yes  
boolean supportsSubqueriesInExists() 1.0 Yes  
boolean supportsSubqueriesInIns() 1.0 Yes  
boolean supportsSubqueriesInQuantifieds() 1.0 Yes  
boolean supportsTableCorrelationNames() 1.0 Yes  
boolean supportsTransactionIsolationLevel(int) 1.0 Yes  
boolean supportsTransactions() 1.0 Yes  
boolean supportsUnion() 1.0 Yes  
boolean supportsUnionAll() 1.0 Yes  
<T> T unwrap(Class<T> iface) 4.0 Yes  
boolean updatesAreDetected(int) 2.0 Core Yes  
boolean usesLocalFilePerTable() 1.0 Yes  
boolean usesLocalFiles() 1.0 Yes