GaussDB-java.sql.DatabaseMetaData
java.sql.DatabaseMetaData是数据库对象定义接口。
| 方法名 | 返回值类型 | 支持JDBC4 |
|---|---|---|
| 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 | Yes |
| getConnection() | Connection | Yes |
| getCrossReference(String parentCatalog, String parentSchema, String parentTable, String foreignCatalog, String foreignSchema, String foreignTable) | ResultSet | Yes |
| getDefaultTransactionIsolation() | int | Yes |
| getExportedKeys(String catalog, String schema, String table) | ResultSet | Yes |
| getExtraNameCharacters() | String | Yes |
| getFunctionColumns(String catalog, String schemaPattern, String functionNamePattern, String columnNamePattern) | ResultSet | Yes |
| getFunctions(String catalog, String schemaPattern, String functionNamePattern) | ResultSet | Yes |
| getIdentifierQuoteString() | String | Yes |
| getImportedKeys(String catalog, String schema, String table) | ResultSet | Yes |
| getIndexInfo(String catalog, String schema, String table, boolean unique, boolean approximate) | ResultSet | 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 |
| getPartitionTablePrimaryKeys(String catalog, String schema, String table) | ResultSet | Yes |
| getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) | ResultSet | Yes |
| getProcedures(String catalog, String schemaPattern, String procedureNamePattern) | ResultSet | Yes |
| getProcedureTerm() | String | 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 | Yes |
| getTimeDateFunctions() | String | Yes |
| getTypeInfo() | ResultSet | Yes |
| getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) | ResultSet | Yes |
| getURL() | String | Yes |
| getVersionColumns(String catalog, String schema, String table) | ResultSet | Yes |
| insertsAreDetected(int type) | boolean | Yes |
| locatorsUpdateCopy() | 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 |
| storesMixedCaseIdentifiers() | boolean | Yes |
| storesUpperCaseIdentifiers() | boolean | Yes |
| supportsBatchUpdates() | boolean | Yes |
| supportsCatalogsInDataManipulation() | boolean | Yes |
| supportsCatalogsInIndexDefinitions() | boolean | Yes |
| supportsCatalogsInPrivilegeDefinitions() | boolean | Yes |
| supportsCatalogsInProcedureCalls() | boolean | Yes |
| supportsCatalogsInTableDefinitions() | boolean | Yes |
| supportsCorrelatedSubqueries() | boolean | Yes |
| supportsDataDefinitionAndDataManipulationTransactions() | boolean | Yes |
| supportsDataManipulationTransactionsOnly() | boolean | Yes |
| supportsGetGeneratedKeys() | boolean | Yes |
| supportsMixedCaseIdentifiers() | boolean | Yes |
| supportsMultipleOpenResults() | boolean | Yes |
| supportsNamedParameters() | boolean | Yes |
| supportsOpenCursorsAcrossCommit() | boolean | Yes |
| supportsOpenCursorsAcrossRollback() | boolean | Yes |
| supportsOpenStatementsAcrossCommit() | boolean | Yes |
| supportsOpenStatementsAcrossRollback() | boolean | Yes |
| supportsPositionedDelete() | boolean | Yes |
| supportsPositionedUpdate() | boolean | Yes |
| supportsRefCursors() | boolean | Yes |
| supportsResultSetConcurrency(int type, int concurrency) | boolean | Yes |
| supportsResultSetType(int type) | 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 |
| supportsTransactionIsolationLevel(int level) | boolean | Yes |
| supportsTransactions() | boolean | Yes |
| supportsUnion() | boolean | Yes |
| supportsUnionAll() | boolean | Yes |
| updatesAreDetected(int type) | boolean | Yes |
| 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 |
getPartitionTablePrimaryKeys(String catalog, String schema, String table)方法用于获取分区表含全局索引的主键列，使用示例如下：
PgDatabaseMetaData dbmd = (PgDatabaseMetaData)conn.getMetaData();
dbmd.getPartitionTablePrimaryKeys( "catalogName", "schemaName", "tableName" );
更多详情请参考GaussDB 文档中心：doc.hcs.huawei.com/db/zh-cn/ga…
