java.sql.DatabaseMetaData
This section describes java.sql.DatabaseMetaData, the API for defining database objects.
| Method Name | Return Type | Support JDBC 4 |
|---|---|---|
| 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 |
The getPartitionTablePrimaryKeys(String catalog, String schema, String table) API is used to obtain the primary key column of a partitioned table that contains global indexes. An example is as follows:
PgDatabaseMetaData dbmd = (PgDatabaseMetaData)conn.getMetaData();
dbmd.getPartitionTablePrimaryKeys("catalogName", "schemaName", "tableName"); Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.