java.sql.DatabaseMetaData
java.sql.DatabaseMetaData is an 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 |
- public ResultSet getProcedures(String catalog, String schemaPattern, String procedureNamePattern)
- public ResultSet getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern)
- public ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types)
- public ResultSet getSchemas(String catalog, String schemaPattern)
- public ResultSet getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)
- public ResultSet getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern)
- public ResultSet getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern)
- public ResultSet getBestRowIdentifier(String catalog, String schema, String table, int scope, boolean nullable)
- public ResultSet getPrimaryKeys(String catalog, String schema, String table)
- protected ResultSet getImportedExportedKeys(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable)
- public ResultSet getIndexInfo(String catalog, String schema, String tableName, boolean unique, boolean approximate)
- public ResultSet getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types)
- public ResultSet getFunctions(String catalog, String schemaPattern, String functionNamePattern)
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
