java.sql.DatabaseMetaData
This section describes java.sql.DatabaseMetaData, the interface for defining database objects.
Method Name |
Return Type |
Support 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 |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.