# java.sql.DatabaseMetaData java.sql.DatabaseMetaData是数据库对象定义接口，具体信息如[表1]所示。 表1对java.sql.DatabaseMetaData的支持情况 | 方法名 | 返回值类型 | 是否支持 | |:---|:---|:---| | allProceduresAreCallable() | BOOLEAN | Yes | | allTablesAreSelectable() | BOOLEAN | Yes | | autoCommitFailureClosesAllResultSets() | BOOLEAN | Yes | | dataDefinitionCausesTransactionCommit() | BOOLEAN | Yes | | dataDefinitionIgnoredInTransactions() | BOOLEAN | Yes | | deletesAreDetected(int type) | BOOLEAN | Yes | | doesMaxRowSizeIncludeBlobs() | BOOLEAN | Yes | | generatedKeyAlwaysReturned() | BOOLEAN | Yes | | getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable) | RESULTSET | Yes | | getCatalogs() | RESULTSET | Yes | | getCatalogSeparator() | STRING | Yes | | getCatalogTerm() | STRING | Yes | | getClientInfoProperties() | RESULTSET | Yes | | getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern) | RESULTSET | No | | getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) | RESULTSET | No | | getConnection() | CONNECTION | Yes | | getCrossReference(String parentCatalog, String parentSchema, String parentTable, String foreignCatalog, String foreignSchema, String foreignTable) | RESULTSET | No | | getDatabaseMajorVersion() | INT | Yes | | getDatabaseMinorVersion() | INT | Yes | | getDatabaseProductName() | STRING | Yes | | getDatabaseProductVersion() | STRING | Yes | | getDefaultTransactionIsolation() | INT | Yes | | getDriverMajorVersion() | INT | Yes | | getDriverMinorVersion() | INT | Yes | | getDriverName() | STRING | Yes | | getDriverVersion() | STRING | Yes | | getExportedKeys(String catalog, String schema, String table) | RESULTSET | No | | getExtraNameCharacters() | STRING | Yes | | getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern) | RESULTSET | No | | getFunctions(String catalog, String schemaPattern, String functionNamePattern) | RESULTSET | No | | getIdentifierQuoteString() | STRING | Yes | | getImportedKeys(String catalog, String schema, String table) | RESULTSET | No | | getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) | RESULTSET | Yes | | getJDBCMajorVersion() | INT | Yes | | getJDBCMinorVersion() | INT | Yes | | getMaxBinaryLiteralLength() | INT | Yes | | getMaxCatalogNameLength() | INT | Yes | | getMaxCharLiteralLength() | INT | Yes | | getMaxColumnNameLength() | INT | Yes | | getMaxColumnsInGroupBy() | INT | Yes | | getMaxColumnsInIndex() | INT | Yes | | getMaxColumnsInOrderBy() | INT | Yes | | getMaxColumnsInSelect() | INT | Yes | | getMaxColumnsInTable() | INT | Yes | | getMaxConnections() | INT | Yes | | getMaxCursorNameLength() | INT | Yes | | getMaxIndexLength() | INT | Yes | | getMaxLogicalLobSize() | DEFAULT LONG | Yes | | getMaxProcedureNameLength() | INT | Yes | | getMaxRowSize() | INT | Yes | | getMaxSchemaNameLength() | INT | Yes | | getMaxStatementLength() | INT | Yes | | getMaxStatements() | INT | Yes | | getMaxTableNameLength() | INT | Yes | | getMaxTablesInSelect() | INT | Yes | | getMaxUserNameLength() | INT | Yes | | getNumericFunctions() | STRING | Yes | | getPrimaryKeys(String catalog, String schema, String table) | RESULTSET | Yes | | getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) | RESULTSET | No | | getProcedures(String catalog, String schemaPattern, String procedureNamePattern) | RESULTSET | No | | getProcedureTerm() | STRING | Yes | | getResultSetHoldability() | INT | Yes | | getSchemas() | RESULTSET | Yes | | getSchemas(String catalog, String schemaPattern) | RESULTSET | Yes | | getSchemaTerm() | STRING | Yes | | getSearchStringEscape() | STRING | Yes | | getSQLKeywords() | STRING | Yes | | getSQLStateType() | INT | Yes | | getStringFunctions() | STRING | Yes | | getSystemFunctions() | STRING | Yes | | getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern) | RESULTSET | No | | getTables(String catalog, String schemaPattern, String tableNamePattern, String\[\] types) | RESULTSET | No | | getTableTypes() | RESULTSET | Yes | | getTimeDateFunctions() | STRING | Yes | | getTypeInfo() | RESULTSET | Yes | | getUDTs(String catalog, String schemaPattern, String typeNamePattern, int\[\] types) | RESULTSET | Yes | | getURL() | STRING | Yes | | getUserName() | STRING | No | | getVersionColumns(String catalog, String schema, String table) | RESULTSET | Yes | | insertsAreDetected(int type) | BOOLEAN | Yes | | isCatalogAtStart() | BOOLEAN | Yes | | isReadOnly() | BOOLEAN | Yes | | locatorsUpdateCopy() | BOOLEAN | Yes | | nullPlusNonNullIsNull() | BOOLEAN | Yes | | nullsAreSortedAtEnd() | BOOLEAN | Yes | | nullsAreSortedAtStart() | BOOLEAN | Yes | | nullsAreSortedHigh() | BOOLEAN | Yes | | nullsAreSortedLow() | BOOLEAN | Yes | | othersDeletesAreVisible(int type) | BOOLEAN | Yes | | othersInsertsAreVisible(int type) | BOOLEAN | Yes | | othersUpdatesAreVisible(int type) | BOOLEAN | Yes | | ownDeletesAreVisible(int type) | BOOLEAN | Yes | | ownInsertsAreVisible(int type) | BOOLEAN | Yes | | ownUpdatesAreVisible(int type) | BOOLEAN | Yes | | storesLowerCaseIdentifiers() | BOOLEAN | Yes | | storesLowerCaseQuotedIdentifiers() | BOOLEAN | Yes | | storesMixedCaseIdentifiers() | BOOLEAN | Yes | | storesMixedCaseQuotedIdentifiers() | BOOLEAN | Yes | | storesUpperCaseIdentifiers() | BOOLEAN | Yes | | storesUpperCaseQuotedIdentifiers() | BOOLEAN | Yes | | supportsAlterTableWithAddColumn() | BOOLEAN | Yes | | supportsAlterTableWithDropColumn() | BOOLEAN | Yes | | supportsANSI92EntryLevelSQL() | BOOLEAN | Yes | | supportsANSI92FullSQL() | BOOLEAN | Yes | | supportsANSI92IntermediateSQL() | BOOLEAN | Yes | | supportsBatchUpdates() | BOOLEAN | Yes | | supportsCatalogsInDataManipulation() | BOOLEAN | Yes | | supportsCatalogsInIndexDefinitions() | BOOLEAN | Yes | | supportsCatalogsInPrivilegeDefinitions() | BOOLEAN | Yes | | supportsCatalogsInProcedureCalls() | BOOLEAN | Yes | | supportsCatalogsInTableDefinitions() | BOOLEAN | Yes | | supportsColumnAliasing() | BOOLEAN | Yes | | supportsConvert() | BOOLEAN | Yes | | supportsConvert(int fromType, int toType) | BOOLEAN | Yes | | supportsCoreSQLGrammar() | BOOLEAN | Yes | | supportsCorrelatedSubqueries() | BOOLEAN | Yes | | supportsDataDefinitionAndDataManipulationTransactions() | BOOLEAN | Yes | | supportsDataManipulationTransactionsOnly() | BOOLEAN | Yes | | supportsDifferentTableCorrelationNames() | BOOLEAN | Yes | | supportsExpressionsInOrderBy() | BOOLEAN | Yes | | supportsExtendedSQLGrammar() | BOOLEAN | Yes | | supportsFullOuterJoins() | BOOLEAN | Yes | | supportsGetGeneratedKeys() | BOOLEAN | Yes | | supportsGroupBy() | BOOLEAN | Yes | | supportsGroupByBeyondSelect() | BOOLEAN | Yes | | supportsGroupByUnrelated() | BOOLEAN | Yes | | supportsIntegrityEnhancementFacility() | BOOLEAN | Yes | | supportsLikeEscapeClause() | BOOLEAN | Yes | | supportsLimitedOuterJoins() | BOOLEAN | Yes | | supportsMinimumSQLGrammar() | BOOLEAN | Yes | | supportsMixedCaseIdentifiers() | BOOLEAN | Yes | | supportsMixedCaseIdentifiers() | BOOLEAN | Yes | | supportsMixedCaseQuotedIdentifiers() | BOOLEAN | Yes | | supportsMultipleOpenResults() | BOOLEAN | Yes | | supportsMultipleResultSets() | BOOLEAN | Yes | | supportsMultipleTransactions() | BOOLEAN | Yes | | supportsNamedParameters() | BOOLEAN | Yes | | supportsNonNullableColumns() | BOOLEAN | Yes | | supportsOpenCursorsAcrossCommit() | BOOLEAN | Yes | | supportsOpenCursorsAcrossRollback() | BOOLEAN | Yes | | supportsOpenStatementsAcrossCommit() | BOOLEAN | Yes | | supportsOpenStatementsAcrossRollback() | BOOLEAN | Yes | | supportsOrderByUnrelated() | BOOLEAN | Yes | | supportsOuterJoins() | BOOLEAN | Yes | | supportsPositionedDelete() | BOOLEAN | Yes | | supportsPositionedUpdate() | BOOLEAN | Yes | | supportsResultSetConcurrency(int type, int concurrency) | BOOLEAN | Yes | | supportsResultSetHoldability(int holdability) | BOOLEAN | Yes | | supportsResultSetType(int type) | BOOLEAN | Yes | | supportsSavepoints() | BOOLEAN | Yes | | supportsSchemasInDataManipulation() | BOOLEAN | Yes | | supportsSchemasInIndexDefinitions() | BOOLEAN | Yes | | supportsSchemasInPrivilegeDefinitions() | BOOLEAN | Yes | | supportsSchemasInProcedureCalls() | BOOLEAN | Yes | | supportsSchemasInTableDefinitions() | BOOLEAN | Yes | | supportsSelectForUpdate() | BOOLEAN | Yes | | supportsStatementPooling() | BOOLEAN | Yes | | supportsStoredFunctionsUsingCallSyntax() | BOOLEAN | Yes | | supportsStoredProcedures() | BOOLEAN | Yes | | supportsSubqueriesInComparisons() | BOOLEAN | Yes | | supportsSubqueriesInExists() | BOOLEAN | Yes | | supportsSubqueriesInIns() | BOOLEAN | Yes | | supportsSubqueriesInQuantifieds() | BOOLEAN | Yes | | supportsTableCorrelationNames() | BOOLEAN | Yes | | supportsTransactionIsolationLevel(int level) | BOOLEAN | Yes | | supportsTransactions() | BOOLEAN | Yes | | supportsUnion() | BOOLEAN | Yes | | supportsUnionAll() | BOOLEAN | Yes | | updatesAreDetected(int type) | BOOLEAN | Yes | | usesLocalFilePerTable() | BOOLEAN | Yes | | usesLocalFiles() | BOOLEAN | Yes |