JavaDatabaseMetaDataMBS.sqlStateSQL99 as Integer

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Indicates that the value is an SQL99 SQLSTATE value.

A possible return value for the method SQLException.getSQLState.

JavaDatabaseMetaDataMBS.sqlStateXOpen as Integer

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Indicates that the value is an X/Open (now know as Open Group) SQL CLI SQLSTATE value.

A possible return value for the method SQLException.getSQLState.

JavaDatabaseMetaDataMBS.storesLowerCaseIdentifiers as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in lower case.

JavaDatabaseMetaDataMBS.storesLowerCaseQuotedIdentifiers as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in lower case.

JavaDatabaseMetaDataMBS.storesMixedCaseIdentifiers as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in mixed case.

JavaDatabaseMetaDataMBS.storesMixedCaseQuotedIdentifiers as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database treats mixed case quoted SQL identifiers as case sensitive and as a result stores them in mixed case.

JavaDatabaseMetaDataMBS.storesUpperCaseIdentifiers as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database treats mixed case unquoted SQL identifiers as case insensitive and stores them in upper case.

JavaDatabaseMetaDataMBS.storesUpperCaseQuotedIdentifiers as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database treats mixed case quoted SQL identifiers as case insensitive and stores them in upper case.

JavaDatabaseMetaDataMBS.supportsAlterTableWithAddColumn as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database supports ALTER TABLE with add column.

JavaDatabaseMetaDataMBS.supportsAlterTableWithDropColumn as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database supports ALTER TABLE with drop column.

JavaDatabaseMetaDataMBS.supportsANSI92EntryLevelSQL as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database supports the ANSI92 entry level SQL grammar.

JavaDatabaseMetaDataMBS.supportsANSI92FullSQL as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database supports the ANSI92 full SQL grammar supported.

JavaDatabaseMetaDataMBS.supportsANSI92IntermediateSQL as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database supports the ANSI92 intermediate SQL grammar supported.

JavaDatabaseMetaDataMBS.supportsBatchUpdates as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database supports batch updates.

Returns:
true if this database supports batch upcates; false otherwise

JavaDatabaseMetaDataMBS.supportsCatalogsInDataManipulation as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether a catalog name can be used in a data manipulation statement.

JavaDatabaseMetaDataMBS.supportsCatalogsInIndexDefinitions as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether a catalog name can be used in an index definition statement.

JavaDatabaseMetaDataMBS.supportsCatalogsInPrivilegeDefinitions as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether a catalog name can be used in an index definition statement.

JavaDatabaseMetaDataMBS.supportsCatalogsInProcedureCalls as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether a catalog name can be used in a procedure call statement.

JavaDatabaseMetaDataMBS.supportsCatalogsInTableDefinitions as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether a catalog name can be used in a table definition statement.

JavaDatabaseMetaDataMBS.supportsColumnAliasing as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database supports column aliasing.

If so, the SQL AS clause can be used to provide names for computed columns or to provide alias names for columns as required.

JavaDatabaseMetaDataMBS.supportsConvert as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database supports the CONVERT function between SQL types.

See also:

• supportsConvert(fromType as Integer, toType as Integer) as boolean

JavaDatabaseMetaDataMBS.supportsConvert(fromType as Integer, toType as Integer) as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database supports the CONVERT for two given SQL types.

Parameters:
fromType - the type to convert from; one of the type codes from the class JavaDatabaseMBS
toType - the type to convert to; one of the type codes from the class JavaDatabaseMBS

Returns:
true if so; false otherwise

See also:

• supportsConvert as boolean

JavaDatabaseMetaDataMBS.supportsCoreSQLGrammar as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database supports the ODBC Core SQL grammar.

JavaDatabaseMetaDataMBS.supportsCorrelatedSubqueries as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database supports correlated subqueries.

JavaDatabaseMetaDataMBS.supportsDataDefinitionAndDataManipulationTransactions as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database supports both data definition and data manipulation statements within a transaction.

JavaDatabaseMetaDataMBS.supportsDataManipulationTransactionsOnly as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database supports only data manipulation statements within a transaction.

JavaDatabaseMetaDataMBS.supportsDifferentTableCorrelationNames as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether, when table correlation names are supported, they are restricted to being different from the names of the tables.

JavaDatabaseMetaDataMBS.supportsExpressionsInOrderBy as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database supports expressions in ORDER BY lists.

JavaDatabaseMetaDataMBS.supportsExtendedSQLGrammar as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database supports the ODBC Extended SQL grammar.

JavaDatabaseMetaDataMBS.supportsFullOuterJoins as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database supports full nested outer joins.

JavaDatabaseMetaDataMBS.supportsGetGeneratedKeys as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether auto-generated keys can be retrieved after a statement has been executed.

Returns:
true if auto-generated keys can be retrieved after a statement has executed; false otherwise

JavaDatabaseMetaDataMBS.supportsGroupBy as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database supports some form of GROUP BY clause.

JavaDatabaseMetaDataMBS.supportsGroupByBeyondSelect as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database supports using columns not included in the SELECT statement in a GROUP BY clause provided that all of the columns in the SELECT statement are included in the GROUP BY clause.

JavaDatabaseMetaDataMBS.supportsGroupByUnrelated as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database supports using a column that is not in the SELECT statement in a GROUP BY clause.

JavaDatabaseMetaDataMBS.supportsIntegrityEnhancementFacility as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database supports the SQL Integrity Enhancement Facility.

JavaDatabaseMetaDataMBS.supportsLikeEscapeClause as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database supports specifying a LIKE escape clause.

JavaDatabaseMetaDataMBS.supportsLimitedOuterJoins as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database provides limited support for outer joins.

(This will be true if the method supportsFullOuterJoins returns true).

JavaDatabaseMetaDataMBS.supportsMinimumSQLGrammar as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database supports the ODBC Minimum SQL grammar.

JavaDatabaseMetaDataMBS.supportsMixedCaseIdentifiers as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database treats mixed case unquoted SQL identifiers as case sensitive and as a result stores them in mixed case.

JavaDatabaseMetaDataMBS.supportsMixedCaseQuotedIdentifiers as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database treats mixed case quoted SQL identifiers as case sensitive and as a result stores them in mixed case.

JavaDatabaseMetaDataMBS.supportsMultipleOpenResults as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether it is possible to have multiple ResultSet objects returned from a CallableStatement object simultaneously.

Returns:
true if a CallableStatement object can return multiple ResultSet objects simultaneously; false otherwise

JavaDatabaseMetaDataMBS.supportsMultipleResultSets as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database supports getting multiple ResultSet objects from a single call to the method execute.

JavaDatabaseMetaDataMBS.supportsMultipleTransactions as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database allows having multiple transactions open at once (on different connections).

JavaDatabaseMetaDataMBS.supportsNamedParameters as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database supports named parameters to callable statements.

Returns:
true if named parameters are supported; false otherwise

JavaDatabaseMetaDataMBS.supportsNonNullableColumns as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether columns in this database may be defined as non-nullable.

JavaDatabaseMetaDataMBS.supportsOpenCursorsAcrossCommit as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database supports keeping cursors open across commits.

JavaDatabaseMetaDataMBS.supportsOpenCursorsAcrossRollback as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database supports keeping cursors open across rollbacks.

JavaDatabaseMetaDataMBS.supportsOpenStatementsAcrossCommit as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database supports keeping statements open across commits.

JavaDatabaseMetaDataMBS.supportsOpenStatementsAcrossRollback as boolean

Type	Topic	Plugin	Version	macOS	Windows	Linux	iOS	Targets
method	Java Database	MBS Java Plugin	8.5	✅ Yes	✅ Yes	✅ Yes	❌ No	Desktop, Console & Web

Retrieves whether this database supports keeping statements open across rollbacks.