|
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
|
|
|
getAttributes(String, String, String, String)
|
3.0
|
Yes
|
The driver returns 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
|
No
|
|
|
ResultSet getColumnPrivileges(String, String, String, String)
|
1.0
|
Yes
|
|
|
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 driver returns an empty result set.
|
|
ResultSet getFunctionColumns()
|
4.0
|
Yes
|
The driver returns an empty result set.
|
|
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
|
Salesforce: SchemaName and ProcedureName must be explicit values; they cannot be patterns.
|
|
ResultSet getProcedures(String, String, String)
|
1.0
|
Yes
|
|
|
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
|
The driver returns an empty result set.
|
|
ResultSet getSuperTypes(String, String, String)
|
3.0
|
Yes
|
The driver returns an empty result set.
|
|
String getSystemFunctions()
|
1.0
|
Yes
|
|
|
ResultSet getTablePrivileges(String, String, String)
|
1.0
|
Yes
|
|
|
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
|
No
|
The driver returns an empty result set.
|
|
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
|