更新日期：2024年09月11日
java.sql.DatabaseMetaData
java.sql.DatabaseMetaData 是数据库对象定义接口。
表8-3 对java.sql.DatabaseMetaData 的支持情况
方法名
返回值类型
支持JDBC 4
allProceduresAreCallable()
boolean
Yes
allTablesAreSelectable()
boolean
Yes
autoCommitFailureClosesAll ResultSets()
boolean
Yes
dataDefinitionCausesTransac tionCommit()
boolean
Yes
dataDefinitionIgnoredInTran sactions()
boolean
Yes
deletesAreDetected(int type)
boolean
Yes
doesMaxRowSizeIncludeBlob s()
boolean
Yes
generatedKeyAlwaysReturne d()
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
GBase 8c V5 开发者手册
南大通用数据技术股份有限公司
221
getConnection()
Connection
Yes
getCrossReference(String
parentCatalog,
String
parentSchema,
String
parentTable,
String
foreignCatalog,
String
foreignSchema,
String
foreignTable)
ResultSet
Yes
getDefaultTransactionIsolati on()
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
getMaxCatalogNameLengt h()
int
Yes
getMaxCharLiteralLength()
int
Yes
getMaxColumnNameLengt h()
int
Yes
getMaxColumnsInGroupBy()
int
Yes
getMaxColumnsInIndex()
int
Yes
getMaxColumnsInOrderBy()
int
Yes
getMaxColumnsInSelect()
int
Yes
GBase 8c V5 开发者手册
南大通用数据技术股份有限公司
222
getMaxColumnsInTable()
int
Yes
getMaxConnections()
int
Yes
getMaxCursorNameLength()
int
Yes
getMaxIndexLength()
int
Yes
getMaxLogicalLobSize()
default long
Yes
getMaxProcedureNameLeng th()
int
Yes
getMaxRowSize()
int
Yes
getMaxSchemaNameLengt h()
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
getPartitionTablePrimaryKey s(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
GBase 8c V5 开发者手册
南大通用数据技术股份有限公司
223
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
GBase 8c V5 开发者手册
南大通用数据技术股份有限公司
224
storesLowerCaseIdentifiers()
boolean
Yes
storesMixedCaseIdentifiers()
boolean
Yes
storesUpperCaseIdentifiers()
boolean
Yes
supportsBatchUpdates()
boolean
Yes
supportsCatalogsInDataMani pulation()
boolean
Yes
supportsCatalogsInIndexDefi nitions()
boolean
Yes
supportsCatalogsInPrivilege Definitions()
boolean
Yes
supportsCatalogsInProcedure Calls()
boolean
Yes
supportsCatalogsInTableDefi nitions()
boolean
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
GBase 8c V5 开发者手册
南大通用数据技术股份有限公司
225
storesMixedCaseIdentifiers()
boolean
Yes
storesUpperCaseIdentifiers()
boolean
Yes
supportsBatchUpdates()
boolean
Yes
supportsCatalogsInDataMani pulation()
boolean
Yes
supportsCatalogsInIndexDefi nitions()
boolean
Yes
supportsCatalogsInPrivilege Definitions()
boolean
Yes
supportsCatalogsInProcedure Calls()
boolean
Yes
supportsCatalogsInTableDefi nitions()
boolean
Yes
supportsCorrelatedSubquerie s()
boolean
Yes
supportsDataDefinitionAndD
ataManipulationTransaction s()
boolean
Yes
supportsDataManipulationTr ansactionsOnly()
boolean
Yes
supportsGetGeneratedKeys()
boolean
Yes
supportsMixedCaseIdentifier s()
boolean
Yes
supportsMultipleOpenResult s()
boolean
Yes
supportsNamedParameters()
boolean
Yes
supportsOpenCursorsAcrossC ommit()
boolean
Yes
supportsOpenCursorsAcrossR ollback()
boolean
Yes
supportsOpenStatementsAcr ossCommit()
boolean
Yes
supportsOpenStatementsAcr ossRollback()
boolean
Yes
supportsPositionedDelete()
boolean
Yes
supportsPositionedUpdate()
boolean
Yes
supportsRefCursors()
boolean
Yes
supportsResultSetConcurrenc
y(int
type,
int
boolean
Yes
GBase 8c V5 开发者手册
南大通用数据技术股份有限公司
226
concurrency)
supportsResultSetType(int type)
boolean
Yes
supportsSchemasInIndexDefi nitions()
boolean
Yes
supportsSchemasInPrivilege Definitions()
boolean
Yes
supportsSchemasInProcedur eCalls()
boolean
Yes
supportsSchemasInTableDefi nitions()
boolean
Yes
supportsSelectForUpdate()
boolean
Yes
supportsStatementPooling()
boolean
Yes
supportsStoredFunctionsUsin gCallSyntax()
boolean
Yes
supportsStoredProcedures()
boolean
Yes
supportsSubqueriesInCompa risons()
boolean
Yes
supportsSubqueriesInExists()
boolean
Yes
supportsSubqueriesInIns()
boolean
Yes
supportsSubqueriesInQuantif ieds()
boolean
Yes
supportsTransactionIsolation Level(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
GBase 8c V5 开发者手册
南大通用数据技术股份有限公司
227
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
supportsMixedCaseIdentifier s()
boolean
Yes
storesUpperCaseIdentifiers()
boolean
Yes
storesLowerCaseIdentifiers()
boolean
Yes
supportsMixedCaseQuotedId entifiers()
boolean
Yes
storesUpperCaseQuotedIden tifiers()
boolean
Yes
storesLowerCaseQuotedIden tifiers()
boolean
Yes
storesMixedCaseQuotedIden tifiers()
boolean
Yes
supportsAlterTableWithAddC olumn()
boolean
Yes
GBase 8c V5 开发者手册
南大通用数据技术股份有限公司
228
supportsAlterTableWithDrop Column()
boolean
Yes
supportsColumnAliasing()
boolean
Yes
nullPlusNonNullIsNull()
boolean
Yes
supportsConvert()
boolean
Yes
supportsConvert(int fromType, int toType)
boolean
Yes
supportsTableCorrelationNa mes()
boolean
Yes
supportsDifferentTableCorrel ationNames()
boolean
Yes
supportsExpressionsInOrderB y()
boolean
Yes
supportsOrderByUnrelated()
boolean
Yes
supportsGroupBy()
boolean
Yes
supportsGroupByUnrelated()
boolean
Yes
supportsGroupByBeyondSele ct()
boolean
Yes
supportsLikeEscapeClause()
boolean
Yes
supportsMultipleResultSets()
boolean
Yes
supportsMultipleTransaction s()
boolean
Yes
supportsNonNullableColumn s()
boolean
Yes
supportsMinimumSQLGram mar()
boolean
Yes
supportsCoreSQLGrammar()
boolean
Yes
supportsExtendedSQLGram mar()
boolean
Yes
supportsANSI92EntryLevelS QL()
boolean
Yes
supportsANSI92Intermediate SQL()
boolean
Yes
supportsANSI92FullSQL()
boolean
Yes
supportsIntegrityEnhanceme ntFacility()
boolean
Yes
GBase 8c V5 开发者手册
南大通用数据技术股份有限公司
229
supportsOuterJoins()
boolean
Yes
supportsFullOuterJoins()
boolean
Yes
supportsLimitedOuterJoins()
boolean
Yes
isCatalogAtStart()
boolean
Yes
supportsSchemasInDataMan ipulation()
boolean
Yes
supportsSavepoints()
boolean
Yes
supportsResultSetHoldabilit y(int holdability)
boolean
Yes
getResultSetHoldability()
int
Yes
getDatabaseMajorVersion()
int
Yes
getDatabaseMinorVersion()
int
Yes
getJDBCMajorVersion()
int
Yes
getJDBCMinorVersion()
int
Yes
uppercaseAttributeName 为true 时，
以下接口会将查询结果转为大写，
可转换范围与java
中的toUpperCase 方法一致。
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)
GBase 8c V5 开发者手册
南大通用数据技术股份有限公司
230
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)
getPartitionTablePrimaryKeys(String catalog, String schema, String table)接口用于获取分
区表含全局索引的主键列，使用示例如下：
PgDatabaseMetaData dbmd = (PgDatabaseMetaData)conn.getMetaData();
dbmd.getPartitionTablePrimaryKeys("catalogName", "schemaName", "tableName");