java.sql.DatabaseMetaData
java.sql.DatabaseMetaData is an API for defining database objects.
|
Method |
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 |
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.