java.sql.DatabaseMetaData
java.sql.DatabaseMetaData是数据库对象定义接口。
| 方法名 | 返回值类型 | 支持JDBC 4 |
|---|---|---|
| getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) | ResultSet | Yes |
| getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) | ResultSet | Yes |
| getTableTypes() | ResultSet | Yes |
| getUserName() | String | Yes |
| isReadOnly() | boolean | Yes |
| nullsAreSortedHigh() | boolean | Yes |
| nullsAreSortedLow() | boolean | Yes |
| nullsAreSortedAtStart() | boolean | Yes |
| nullsAreSortedAtEnd() | boolean | Yes |
| getDatabaseProductName() | String | Yes |
| getDatabaseProductVersion() | String | Yes |
| getDriverName() | String | Yes |
| getDriverVersion() | String | Yes |
| getDriverMajorVersion() | int | Yes |
| getDriverMinorVersion() | int | Yes |
| usesLocalFiles() | boolean | Yes |
| usesLocalFilePerTable() | boolean | Yes |
| supportsMixedCaseIdentifiers() | boolean | Yes |
| storesUpperCaseIdentifiers() | boolean | Yes |
| storesLowerCaseIdentifiers() | boolean | Yes |
| supportsMixedCaseQuotedIdentifiers() | boolean | Yes |
| storesUpperCaseQuotedIdentifiers() | boolean | Yes |
| storesLowerCaseQuotedIdentifiers() | boolean | Yes |
| storesMixedCaseQuotedIdentifiers() | boolean | Yes |
| supportsAlterTableWithAddColumn() | boolean | Yes |
| supportsAlterTableWithDropColumn() | boolean | Yes |
| supportsColumnAliasing() | boolean | Yes |
| nullPlusNonNullIsNull() | boolean | Yes |
| supportsConvert() | boolean | Yes |
| supportsConvert(int fromType, int toType) | boolean | Yes |
| supportsTableCorrelationNames() | boolean | Yes |
| supportsDifferentTableCorrelationNames() | boolean | Yes |
| supportsExpressionsInOrderBy() | boolean | Yes |
| supportsOrderByUnrelated() | boolean | Yes |
| supportsGroupBy() | boolean | Yes |
| supportsGroupByUnrelated() | boolean | Yes |
| supportsGroupByBeyondSelect() | boolean | Yes |
| supportsLikeEscapeClause() | boolean | Yes |
| supportsMultipleResultSets() | boolean | Yes |
| supportsMultipleTransactions() | boolean | Yes |
| supportsNonNullableColumns() | boolean | Yes |
| supportsMinimumSQLGrammar() | boolean | Yes |
| supportsCoreSQLGrammar() | boolean | Yes |
| supportsExtendedSQLGrammar() | boolean | Yes |
| supportsANSI92EntryLevelSQL() | boolean | Yes |
| supportsANSI92IntermediateSQL() | boolean | Yes |
| supportsANSI92FullSQL() | boolean | Yes |
| supportsIntegrityEnhancementFacility() | boolean | Yes |
| supportsOuterJoins() | boolean | Yes |
| supportsFullOuterJoins() | boolean | Yes |
| supportsLimitedOuterJoins() | boolean | Yes |
| isCatalogAtStart() | boolean | Yes |
| supportsSchemasInDataManipulation() | boolean | Yes |
| supportsSavepoints() | boolean | Yes |
| supportsResultSetHoldability(int holdability) | boolean | Yes |
| getResultSetHoldability() | int | Yes |
| getDatabaseMajorVersion() | int | Yes |
| getDatabaseMinorVersion() | int | Yes |
| getJDBCMajorVersion() | int | Yes |
| getJDBCMinorVersion() | int | Yes |
