数据仓库服务 GAUSSDB(DWS)-JDBC接口参考:java.sql.DatabaseMetaData
下载数据仓库服务 GAUSSDB(DWS)用户手册完整版
java.sql.DatabaseMetaData
java.sql.DatabaseMetaData是数据库对象定义接口。
|
方法名 |
返回值类型 |
支持JDBC 4 |
|---|---|---|
|
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 |
- 数据仓库服务GaussDB(DWS)_SQL on Anywhere
- 调用GaussDB(DWS) API接口_数据仓库服务调用API_如何调用API_在DWS中调用API
- GAUSS(DWS)工具_gsql工具_DataStudio工具_DSC工具
- DWS安全_数据仓库服务安全_DWS数据安全管理_DWS安全保障_DWS安全策略
- DWS产品介绍_DWS产品优势_DWS功能_DWS使用场景_DWS是什么
- 什么是数据湖探索服务_数据湖探索DLI用途与特点
- DWS资源管理_GaussDB(DWS)资源管理作用_DWS资源管控
- 数据库监控DMS_数据库智能运维_了解Auto Pilot_DMS_DWS节点监控
- GaussDB(DWS)常用SQL_常用SQL命令_SQL语法
- 如何进行日志采集和转储_日志平台_日志接入_日志转储
