Platforms to show: All Mac Windows Linux Cross-Platform
Back to JavaDatabaseMetaDataMBS class.
JavaDatabaseMetaDataMBS.getTables(catalog as string, schemaPattern as string, tableNamePattern as string) as JavaResultSetMBS
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | Java Database | MBS Java Plugin | 9.1 | ✅ Yes | ✅ Yes | ✅ Yes | ❌ No | Desktop, Console & Web |
Only table descriptions matching the catalog, schema, table name and type criteria are returned. They are ordered by TABLE_TYPE, TABLE_SCHEM and TABLE_NAME.
Each table description has the following columns:
TABLE_CAT String => table catalog (may be null)
TABLE_SCHEM String => table schema (may be null)
TABLE_NAME String => table name
TABLE_TYPE String => table type. Typical types are "TABLE", "VIEW", | "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM". |
TYPE_CAT String => the types catalog (may be null)
TYPE_SCHEM String => the types schema (may be null)
TYPE_NAME String => type name (may be null)
SELF_REFERENCING_COL_NAME String => name of the designated "identifier" column of a typed table (may be null)
REF_GENERATION String => specifies how values in SELF_REFERENCING_COL_NAME are created. Values are "SYSTEM", "USER", "DERIVED". (may be null)
Note: Some databases may not return information for all tables.
Parameters:
catalog - a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search
schemaPattern - a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search
tableNamePattern - a table name pattern; must match the table name as it is stored in the database
types - a list of table types to include (optionally)
Returns:
ResultSet - each row is a table description
Throws:
SQLException - if a database access error occurs
See also:
JavaDatabaseMetaDataMBS.getTables(catalog as string, schemaPattern as string, tableNamePattern as string, types() as string) as JavaResultSetMBS
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | Java Database | MBS Java Plugin | 9.1 | ✅ Yes | ✅ Yes | ✅ Yes | ❌ No | Desktop, Console & Web |
Only table descriptions matching the catalog, schema, table name and type criteria are returned. They are ordered by TABLE_TYPE, TABLE_SCHEM and TABLE_NAME.
Each table description has the following columns:
TABLE_CAT String => table catalog (may be null)
TABLE_SCHEM String => table schema (may be null)
TABLE_NAME String => table name
TABLE_TYPE String => table type. Typical types are "TABLE", "VIEW", | "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM". |
TYPE_CAT String => the types catalog (may be null)
TYPE_SCHEM String => the types schema (may be null)
TYPE_NAME String => type name (may be null)
SELF_REFERENCING_COL_NAME String => name of the designated "identifier" column of a typed table (may be null)
REF_GENERATION String => specifies how values in SELF_REFERENCING_COL_NAME are created. Values are "SYSTEM", "USER", "DERIVED". (may be null)
Note: Some databases may not return information for all tables.
Parameters:
catalog - a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search
schemaPattern - a schema name pattern; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search
tableNamePattern - a table name pattern; must match the table name as it is stored in the database
types - a list of table types to include (optionally)
Returns:
ResultSet - each row is a table description
Throws:
SQLException - if a database access error occurs
See also:
JavaDatabaseMetaDataMBS.getTableTypes as JavaResultSetMBS
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | Java Database | MBS Java Plugin | 9.1 | ✅ Yes | ✅ Yes | ✅ Yes | ❌ No | Desktop, Console & Web |
The table type is:
TABLE_TYPE String => table type. Typical types are "TABLE", "VIEW", | "SYSTEM TABLE", "GLOBAL TEMPORARY", "LOCAL TEMPORARY", "ALIAS", "SYNONYM". |
Returns:
a ResultSet object in which each row has a single String column that is a table type
Throws:
SQLException - if a database access error occurs
JavaDatabaseMetaDataMBS.getTimeDateFunctions as string
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | Java Database | MBS Java Plugin | 8.5 | ✅ Yes | ✅ Yes | ✅ Yes | ❌ No | Desktop, Console & Web |
JavaDatabaseMetaDataMBS.getTypeInfos as JavaResultSetMBS
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | Java Database | MBS Java Plugin | 9.1 | ✅ Yes | ✅ Yes | ✅ Yes | ❌ No | Desktop, Console & Web |
They are ordered by DATA_TYPE and then by how closely the data type maps to the corresponding JDBC SQL type.
Each type description has the following columns:
TYPE_NAME String => Type name
DATA_TYPE int => SQL data type from java.sql.Types
PRECISION int => maximum precision
LITERAL_PREFIX String => prefix used to quote a literal (may be null)
LITERAL_SUFFIX String => suffix used to quote a literal (may be null)
CREATE_PARAMS String => parameters used in creating the type (may be null)
NULLABLE short => can you use NULL for this type.
typeNoNulls - does not allow NULL values
typeNullable - allows NULL values
typeNullableUnknown - nullability unknown
CASE_SENSITIVE boolean=> is it case sensitive.
SEARCHABLE short => can you use "WHERE" based on this type:
typePredNone - No support
typePredChar - Only supported with WHERE .. LIKE
typePredBasic - Supported except for WHERE .. LIKE
typeSearchable - Supported for all WHERE ..
UNSIGNED_ATTRIBUTE boolean => is it unsigned.
FIXED_PREC_SCALE boolean => can it be a money value.
AUTO_INCREMENT boolean => can it be used for an auto-increment value.
LOCAL_TYPE_NAME String => localized version of type name (may be null)
MINIMUM_SCALE short => minimum scale supported
MAXIMUM_SCALE short => maximum scale supported
SQL_DATA_TYPE int => unused
SQL_DATETIME_SUB int => unused
NUM_PREC_RADIX int => usually 2 or 10
Returns:
a ResultSet object in which each row is an SQL type description
Throws:
SQLException - if a database access error occurs
This method is named getTypeInfo in Java and getTypeInfos in this plugin because Xojo has a global method and sees a conflict.
JavaDatabaseMetaDataMBS.getURL as string
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | Java Database | MBS Java Plugin | 8.5 | ✅ Yes | ✅ Yes | ✅ Yes | ❌ No | Desktop, Console & Web |
Returns the URL for this DBMS or "" if it cannot be generated.
JavaDatabaseMetaDataMBS.getUserName as string
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | Java Database | MBS Java Plugin | 8.5 | ✅ Yes | ✅ Yes | ✅ Yes | ❌ No | Desktop, Console & Web |
JavaDatabaseMetaDataMBS.getVersionColumns(catalog as string, schema as string, table as string) as JavaResultSetMBS
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
method | Java Database | MBS Java Plugin | 9.1 | ✅ Yes | ✅ Yes | ✅ Yes | ❌ No | Desktop, Console & Web |
Each column description has the following columns:
SCOPE short => is not used
COLUMN_NAME String => column name
DATA_TYPE int => SQL data type from java.sql.Types
TYPE_NAME String => Data source-dependent type name
COLUMN_SIZE int => precision
BUFFER_LENGTH int => length of column value in bytes
DECIMAL_DIGITS short | => scale |
versionColumnUnknown - may or may not be pseudo column
versionColumnNotPseudo - is NOT a pseudo column
versionColumnPseudo - is a pseudo column
Parameters:
catalog - a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means that the catalog name should not be used to narrow the search
schema - a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means that the schema name should not be used to narrow the search
table - a table name; must match the table name as it is stored in the database
Returns:
a ResultSet object in which each row is a column description
JavaDatabaseMetaDataMBS.importedKeyCascade 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 |
For the column DELETE_RULE, it indicates that when the primary key is deleted, rows that imported that key are deleted.
A possible value for the columns UPDATE_RULE and DELETE_RULE in the ResultSet objects returned by the methods getImportedKeys, getExportedKeys, and getCrossReference.
JavaDatabaseMetaDataMBS.importedKeyInitiallyDeferred 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 |
A possible value for the column DEFERRABILITY in the ResultSet objects returned by the methods getImportedKeys, getExportedKeys, and getCrossReference.
JavaDatabaseMetaDataMBS.importedKeyInitiallyImmediate 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 |
A possible value for the column DEFERRABILITY in the ResultSet objects returned by the methods getImportedKeys, getExportedKeys, and getCrossReference.
JavaDatabaseMetaDataMBS.importedKeyNoAction 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 |
A possible value for the columns UPDATE_RULE and DELETE_RULE in the ResultSet objects returned by the methods getImportedKeys, getExportedKeys, and getCrossReference.
JavaDatabaseMetaDataMBS.importedKeyNotDeferrable 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 |
A possible value for the column DEFERRABILITY in the ResultSet objects returned by the methods getImportedKeys, getExportedKeys, and getCrossReference.
JavaDatabaseMetaDataMBS.importedKeyRestrict 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 |
For the column DELETE_RULE, indicates that a primary key may not be deleted if it has been imported by another table as a foreign key.
A possible value for the columns UPDATE_RULE and DELETE_RULE in the ResultSet objects returned by the methods getImportedKeys, getExportedKeys, and getCrossReference.
JavaDatabaseMetaDataMBS.importedKeySetDefault 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 |
A possible value for the columns UPDATE_RULE and DELETE_RULE in the ResultSet objects returned by the methods getImportedKeys, getExportedKeys, and getCrossReference.
JavaDatabaseMetaDataMBS.importedKeySetNull 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 |
A possible value for the columns UPDATE_RULE and DELETE_RULE in the ResultSet objects returned by the methods getImportedKeys, getExportedKeys, and getCrossReference.
JavaDatabaseMetaDataMBS.insertsAreDetected(type 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 |
Parameters:
type - the ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
Returns:
true if changes are detected by the specified result set type; false otherwise
JavaDatabaseMetaDataMBS.isCatalogAtStart 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 |
JavaDatabaseMetaDataMBS.isReadOnly 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 |
JavaDatabaseMetaDataMBS.locatorsUpdateCopy 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 |
Returns:
true if updates are made to a copy of the LOB; false if updates are made directly to the LOB
JavaDatabaseMetaDataMBS.nullPlusNonNullIsNull 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 |
JavaDatabaseMetaDataMBS.nullsAreSortedAtEnd 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 |
JavaDatabaseMetaDataMBS.nullsAreSortedAtStart 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 |
JavaDatabaseMetaDataMBS.nullsAreSortedHigh 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 |
Sorted high means that NULL values sort higher than any other value in a domain. In an ascending order, if this method returns true, NULL values will appear at the end. By contrast, the method nullsAreSortedAtEnd indicates whether NULL values are sorted at the end regardless of sort order.
JavaDatabaseMetaDataMBS.nullsAreSortedLow 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 |
Sorted low means that NULL values sort lower than any other value in a domain. In an ascending order, if this method returns true, NULL values will appear at the beginning. By contrast, the method nullsAreSortedAtStart indicates whether NULL values are sorted at the beginning regardless of sort order.
JavaDatabaseMetaDataMBS.othersDeletesAreVisible(type 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 |
Parameters:
type - the ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
Returns:
true if deletes made by others are visible for the given result set type; false otherwise
JavaDatabaseMetaDataMBS.othersInsertsAreVisible(type 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 |
Parameters:
type - the ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
Returns:
true if inserts made by others are visible for the given result set type; false otherwise
JavaDatabaseMetaDataMBS.othersUpdatesAreVisible(type 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 |
Parameters:
type - the ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
Returns:
true if updates made by others are visible for the given result set type; false otherwise
JavaDatabaseMetaDataMBS.ownDeletesAreVisible(type 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 |
type - the ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
Returns true if deletes are visible for the given result set type; false otherwise
JavaDatabaseMetaDataMBS.ownInsertsAreVisible(type 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 |
type - the ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
Returns true if inserts are visible for the given result set type; false otherwise
JavaDatabaseMetaDataMBS.ownUpdatesAreVisible(type 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 |
type - the ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE
JavaDatabaseMetaDataMBS.procedureColumnIn 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 |
A possible value for the column COLUMN_TYPE in the ResultSet returned by the method getProcedureColumns.
JavaDatabaseMetaDataMBS.procedureColumnInOut 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 |
A possible value for the column COLUMN_TYPE in the ResultSet returned by the method getProcedureColumns.
JavaDatabaseMetaDataMBS.procedureColumnOut 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 |
A possible value for the column COLUMN_TYPE in the ResultSet returned by the method getProcedureColumns.
JavaDatabaseMetaDataMBS.procedureColumnResult 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 |
A possible value for the column COLUMN_TYPE in the ResultSet returned by the method getProcedureColumns.
JavaDatabaseMetaDataMBS.procedureColumnReturn 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 |
A possible value for the column COLUMN_TYPE in the ResultSet returned by the method getProcedureColumns.
JavaDatabaseMetaDataMBS.procedureColumnUnknown 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 |
A possible value for the column COLUMN_TYPE in the ResultSet returned by the method getProcedureColumns.
JavaDatabaseMetaDataMBS.procedureNoNulls 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 |
A possible value for the column NULLABLE in the ResultSet object returned by the method getProcedureColumns.
JavaDatabaseMetaDataMBS.procedureNoResult 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 |
A possible value for column PROCEDURE_TYPE in the ResultSet object returned by the method getProcedures.
JavaDatabaseMetaDataMBS.procedureNullable 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 |
A possible value for the column NULLABLE in the ResultSet object returned by the method getProcedureColumns.
JavaDatabaseMetaDataMBS.procedureNullableUnknown 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 |
A possible value for the column NULLABLE in the ResultSet object returned by the method getProcedureColumns.
JavaDatabaseMetaDataMBS.procedureResultUnknown 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 |
A possible value for column PROCEDURE_TYPE in the ResultSet object returned by the method getProcedures.
JavaDatabaseMetaDataMBS.procedureReturnsResult 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 |
A possible value for column PROCEDURE_TYPE in the ResultSet object returned by the method getProcedures.
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 |
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 |
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 |
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 |
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 |
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 |
The items on this page are in the following plugins: MBS Java Plugin.