java.sql.DatabaseMetaData
This section describes java.sql.DatabaseMetaData, the interface 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.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot
