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 |
|
ResultSet getBestRowIdentifier (String, String, String, int, boolean) |
1.0 |
Yes |
|
String getCatalogSeparator () |
1.0 |
Yes |
|
String getCatalogTerm () |
1.0 |
Yes |
|
ResultSet getCatalogs () |
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 |
|
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 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 |
|
String getProcedureTerm () |
1.0 |
Yes |
|
ResultSet getProcedures (String, String, String) |
1.0 |
Yes |
|
String getSQLKeywords () |
1.0 |
Yes |
|
String getSchemaTerm () |
1.0 |
Yes |
|
ResultSet getSchemas () |
1.0 |
Yes |
|
String getSearchStringEscape () |
1.0 |
Yes |
|
String getStringFunctions () |
1.0 |
Yes |
|
String getSystemFunctions () |
1.0 |
Yes |
|
ResultSet getTablePrivileges (String, String, String) |
1.0 |
Yes |
|
ResultSet getTableTypes () |
1.0 |
Yes |
|
ResultSet getTables (String, String, String, String []) |
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 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 supportsANSI92EntryLevelSQL () |
1.0 |
Yes |
|
boolean supportsANSI92FullSQL () |
1.0 |
Yes |
|
boolean supportsANSI92Intermediate SQL () |
1.0 |
Yes |
|
boolean supportsAlterTableWith AddColumn () |
1.0 |
Yes |
|
boolean supportsAlterTableWith DropColumn () |
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 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 supportsMultipleResultSets () |
1.0 |
Yes |
|
boolean supportsMultipleTransactions () |
1.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 supportsResultSetType (int) |
2.0 Core |
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 |
|