|
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 drivers for Apache Cassandra, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce 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, 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 drivers for Apache Cassandra, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce return an empty result set.
Not supported by the drivers for Apache Hive, Apache Spark SQL, or Impala.
|
|
ResultSet getFunctionColumns()
|
4.0
|
Yes
|
The drivers for Apache Cassandra, MongoDB, Oracle Eloqua, Oracle Sales Cloud, Oracle Service Cloud, and Salesforce return an empty result set.
Not supported by the drivers for Apache Hive, Apache Spark SQL, or 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 drivers for Oracle Service Cloud, and Salesforce, 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 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 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, 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
|
|