Compute
Elastic Cloud Server
Huawei Cloud Flexus
Bare Metal Server
Auto Scaling
Image Management Service
Dedicated Host
FunctionGraph
Cloud Phone Host
Huawei Cloud EulerOS
Networking
Virtual Private Cloud
Elastic IP
Elastic Load Balance
NAT Gateway
Direct Connect
Virtual Private Network
VPC Endpoint
Cloud Connect
Enterprise Router
Enterprise Switch
Global Accelerator
Management & Governance
Cloud Eye
Identity and Access Management
Cloud Trace Service
Resource Formation Service
Tag Management Service
Log Tank Service
Config
OneAccess
Resource Access Manager
Simple Message Notification
Application Performance Management
Application Operations Management
Organizations
Optimization Advisor
IAM Identity Center
Cloud Operations Center
Resource Governance Center
Migration
Server Migration Service
Object Storage Migration Service
Cloud Data Migration
Migration Center
Cloud Ecosystem
KooGallery
Partner Center
User Support
My Account
Billing Center
Cost Center
Resource Center
Enterprise Management
Service Tickets
HUAWEI CLOUD (International) FAQs
ICP Filing
Support Plans
My Credentials
Customer Operation Capabilities
Partner Support Plans
Professional Services
Analytics
MapReduce Service
Data Lake Insight
CloudTable Service
Cloud Search Service
Data Lake Visualization
Data Ingestion Service
GaussDB(DWS)
DataArts Studio
Data Lake Factory
DataArts Lake Formation
IoT
IoT Device Access
Others
Product Pricing Details
System Permissions
Console Quick Start
Common FAQs
Instructions for Associating with a HUAWEI CLOUD Partner
Message Center
Security & Compliance
Security Technologies and Applications
Web Application Firewall
Host Security Service
Cloud Firewall
SecMaster
Anti-DDoS Service
Data Encryption Workshop
Database Security Service
Cloud Bastion Host
Data Security Center
Cloud Certificate Manager
Edge Security
Managed Threat Detection
Blockchain
Blockchain Service
Web3 Node Engine Service
Media Services
Media Processing Center
Video On Demand
Live
SparkRTC
MetaStudio
Storage
Object Storage Service
Elastic Volume Service
Cloud Backup and Recovery
Storage Disaster Recovery Service
Scalable File Service Turbo
Scalable File Service
Volume Backup Service
Cloud Server Backup Service
Data Express Service
Dedicated Distributed Storage Service
Containers
Cloud Container Engine
SoftWare Repository for Container
Application Service Mesh
Ubiquitous Cloud Native Service
Cloud Container Instance
Databases
Relational Database Service
Document Database Service
Data Admin Service
Data Replication Service
GeminiDB
GaussDB
Distributed Database Middleware
Database and Application Migration UGO
TaurusDB
Middleware
Distributed Cache Service
API Gateway
Distributed Message Service for Kafka
Distributed Message Service for RabbitMQ
Distributed Message Service for RocketMQ
Cloud Service Engine
Multi-Site High Availability Service
EventGrid
Dedicated Cloud
Dedicated Computing Cluster
Business Applications
Workspace
ROMA Connect
Message & SMS
Domain Name Service
Edge Data Center Management
Meeting
AI
Face Recognition Service
Graph Engine Service
Content Moderation
Image Recognition
Optical Character Recognition
ModelArts
ImageSearch
Conversational Bot Service
Speech Interaction Service
Huawei HiLens
Video Intelligent Analysis Service
Developer Tools
SDK Developer Guide
API Request Signing Guide
Terraform
Koo Command Line Interface
Content Delivery & Edge Computing
Content Delivery Network
Intelligent EdgeFabric
CloudPond
Intelligent EdgeCloud
Solutions
SAP Cloud
High Performance Computing
Developer Services
ServiceStage
CodeArts
CodeArts PerfTest
CodeArts Req
CodeArts Pipeline
CodeArts Build
CodeArts Deploy
CodeArts Artifact
CodeArts TestPlan
CodeArts Check
CodeArts Repo
Cloud Application Engine
MacroVerse aPaaS
KooMessage
KooPhone
KooDrive
On this page

Show all

java.sql.DatabaseMetaData

Updated on 2024-05-07 GMT+08:00

java.sql.DatabaseMetaData is an API for defining database objects.

Table 1 Support status for java.sql.DatabaseMetaData

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

NOTE:
If the value of uppercaseAttributeName is true, the following APIs convert the query result to uppercase letters. The conversion range is the same as that of the toUpperCase method in Java.
  • 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)
CAUTION:

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");

We use cookies to improve our site and your experience. By continuing to browse our site you accept our cookie policy. Find out more

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback