Table A-7
DatabaseMetaData Object
Methods
|
Version
Introduced
|
Supported
|
Comments
|
boolean allProceduresAreCallable ()
|
1.0
|
Yes
|
|
boolean allTablesAreSelectable ()
|
1.0
|
Yes
|
|
boolean dataDefinitionCausesTransaction Commit ()
|
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.
|
ResultSet getAttributes (String, String, String, String)
|
3.0
|
No
|
Throws "unsupported method" exception.
|
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
|
|
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
|
|
int getDatabaseMajorVersion ()
|
3.0
|
Yes
|
|
int getDatabaseMinorVersion ()
|
3.0
|
Yes
|
|
String getDatabaseProductName ()
|
1.0
|
Yes
|
For Sybase, returns "SQL Server," which is the string returned internally by the Sybase database server. This value may not be the same return as seen with other JDBC drivers, including the Sybase JConnect JDBC drivers.
|
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
|
|
ResultSet getProcedures (String, String, String)
|
1.0
|
Yes
|
|
String getProcedureTerm ()
|
1.0
|
Yes
|
|
int getResultSetHoldability ()
|
3.0
|
Yes
|
|
ResultSet getSchemas ()
|
1.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
|
No
|
Throws "unsupported method" exception.
|
ResultSet getSuperTypes (String, String, String)
|
3.0
|
No
|
Throws "unsupported method" exception.
|
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
|
Always returns empty ResultSet.
|
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 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 storesLowerCaseQuoted Identifiers ()
|
1.0
|
Yes
|
|
boolean storesMixedCaseIdentifiers ()
|
1.0
|
Yes
|
|
boolean storesMixedCaseQuoted Identifiers ()
|
1.0
|
Yes
|
|
boolean storesUpperCaseIdentifiers ()
|
1.0
|
Yes
|
|
boolean storesUpperCaseQuoted Identifiers ()
|
1.0
|
Yes
|
|
boolean supportsAlterTableWith AddColumn ()
|
1.0
|
Yes
|
|
boolean supportsAlterTableWith DropColumn ()
|
1.0
|
Yes
|
|
boolean supportsANSI92EntryLevelSQL ()
|
1.0
|
Yes
|
|
boolean supportsANSI92FullSQL ()
|
1.0
|
Yes
|
|
boolean supportsANSI92Intermediate SQL ()
|
1.0
|
Yes
|
|
boolean supportsBatchUpdates ()
|
2.0 Core
|
Yes
|
|
boolean supportsCatalogsInData Manipulation ()
|
1.0
|
Yes
|
|
boolean supportsCatalogsInIndex Definitions ()
|
1.0
|
Yes
|
|
boolean supportsCatalogsInPrivilege Definitions ()
|
1.0
|
Yes
|
|
boolean supportsCatalogsInProcedure Calls ()
|
1.0
|
Yes
|
|
boolean supportsCatalogsInTable Definitions ()
|
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 supportsDataManipulation TransactionsOnly ()
|
1.0
|
Yes
|
|
boolean supportsDifferentTableCorrelation Names ()
|
1.0
|
Yes
|
|
boolean supportsExpressionsIn OrderBy ()
|
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 supportsIntegrityEnhancement Facility ()
|
1.0
|
Yes
|
|
boolean supportsLikeEscapeClause ()
|
1.0
|
Yes
|
|
boolean supportsLimitedOuterJoins ()
|
1.0
|
Yes
|
|
boolean supportsMinimumSQLGrammar ()
|
1.0
|
Yes
|
|
boolean supportsMixedCaseIdentifiers ()
|
1.0
|
Yes
|
|
boolean supportsMixedCaseQuoted Identifiers ()
|
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 supportsOpenCursorsAcross Commit ()
|
1.0
|
Yes
|
|
boolean supportsOpenCursorsAcross Rollback ()
|
1.0
|
Yes
|
|
boolean supportsOpenStatementsAcross Commit ()
|
1.0
|
Yes
|
|
boolean supportsOpenStatementsAcross Rollback ()
|
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 supportsSchemasInData Manipulation ()
|
1.0
|
Yes
|
|
boolean supportsSchemasInIndex Definitions ()
|
1.0
|
Yes
|
|
boolean supportsSchemasIn PrivilegeDefinitions ()
|
1.0
|
Yes
|
|
boolean supportsSchemasInProcedure Calls ()
|
1.0
|
Yes
|
|
boolean supportsSchemasInTable Definitions ()
|
1.0
|
Yes
|
|
boolean supportsSelectForUpdate ()
|
1.0
|
Yes
|
|
boolean supportsStoredProcedures ()
|
1.0
|
Yes
|
|
boolean supportsSubqueriesIn Comparisons ()
|
1.0
|
Yes
|
|
boolean supportsSubqueriesInExists ()
|
1.0
|
Yes
|
|
boolean supportsSubqueriesInIns ()
|
1.0
|
Yes
|
|
boolean supportsSubqueriesIn Quantifieds ()
|
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
|
|
boolean updatesAreDetected (int)
|
2.0 Core
|
Yes
|
|
boolean usesLocalFilePerTable ()
|
1.0
|
Yes
|
|
boolean usesLocalFiles ()
|
1.0
|
Yes
|
|