JavaDatabaseMetaDataMBS.getAttributes(catalog as string, schemaPattern as string, typeNamePattern as string, attributeNamePattern 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

Retrieves a description of the given attribute of the given type for a user-defined type (UDT) that is available in the given schema and catalog.

Descriptions are returned only for attributes of UDTs matching the catalog, schema, type, and attribute name criteria. They are ordered by TYPE_SCHEM, TYPE_NAME and ORDINAL_POSITION. This description does not contain inherited attributes.

The ResultSet object that is returned has the following columns:

TYPE_CAT String => type catalog (may be null)
TYPE_SCHEM String => type schema (may be null)
TYPE_NAME String => type name
ATTR_NAME String => attribute name
DATA_TYPE int => attribute type SQL type from java.sql.Types
ATTR_TYPE_NAME String => Data source dependent type name. For a UDT, the type name is fully qualified. For a REF, the type name is fully qualified and represents the target type of the reference type.
ATTR_SIZE int => column size. For char or date types this is the maximum number of characters; for numeric or decimal types this is precision.
DECIMAL_DIGITS int => the number of fractional digits
NUM_PREC_RADIX int => Radix (typically either 10 or 2)
NULLABLE int => whether NULL is allowed
attributeNoNulls - might not allow NULL values
attributeNullable - definitely allows NULL values
attributeNullableUnknown - nullability unknown
REMARKS String => comment describing column (may be null)
ATTR_DEF String => default value (may be null)
SQL_DATA_TYPE int => unused
SQL_DATETIME_SUB int => unused
CHAR_OCTET_LENGTH int => for char types the maximum number of bytes in the column
ORDINAL_POSITION int => index of column in table (starting at 1)
IS_NULLABLE String => "false" means column definitely does not allow NULL values; "true" means the column might allow NULL values. An empty string means unknown.
SCOPE_CATALOG String => catalog of table that is the scope of a reference attribute (null if DATA_TYPE isn't REF)
SCOPE_SCHEMA String => schema of table that is the scope of a reference attribute (null if DATA_TYPE isn't REF)
SCOPE_TABLE String => table name that is the scope of a reference attribute (null if the DATA_TYPE isn't REF)
SOURCE_DATA_TYPE short => source type of a distinct type or user-generated Ref type,SQL type from java.sql.Types (null if DATA_TYPE isn't DISTINCT or user-generated REF)
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
typeNamePattern - a type name pattern; must match the type name as it is stored in the database
attributeNamePattern - an attribute name pattern; must match the attribute name as it is declared in the database

Returns:
a ResultSet object in which each row is an attribute description

Throws:
SQLException - if a database access error occurs

JavaDatabaseMetaDataMBS.getCatalogs 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

Retrieves the catalog names available in this database. The results are ordered by catalog name.

The catalog column is:

TABLE_CAT String => catalog name

Returns:
a ResultSet object in which each row has a single String column that is a catalog name

Throws:
SQLException - if a database access error occurs

JavaDatabaseMetaDataMBS.getCatalogSeparator 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

Retrieves the String that this database uses as the separator between a catalog and table name.

JavaDatabaseMetaDataMBS.getCatalogTerm 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

Retrieves the database vendor's preferred term for "catalog".

JavaDatabaseMetaDataMBS.getColumnPrivileges(catalog as string, schema as string, table as string, columnNamePattern 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

Retrieves a description of the access rights for a table's columns.

Only privileges matching the column name criteria are returned. They are ordered by COLUMN_NAME and PRIVILEGE.

Each privilige 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
COLUMN_NAME String => column name
GRANTOR => grantor of access (may be null)
GRANTEE String => grantee of access
PRIVILEGE String => name of access (SELECT, INSERT, UPDATE, REFRENCES, ...)
IS_GRANTABLE String => "true" if grantee is permitted to grant to others; "false" if not; null if unknown
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
columnNamePattern - a column name pattern; must match the column name as it is stored in the database

Returns:
ResultSet - each row is a column privilege description

Throws:
SQLException - if a database access error occurs

JavaDatabaseMetaDataMBS.getColumns(catalog as string, schemaPattern as string, tableNamePattern as string, columnNamePattern 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

Retrieves a description of table columns available in the specified catalog.

Only column descriptions matching the catalog, schema, table and column name criteria are returned. They are ordered by TABLE_SCHEM, TABLE_NAME, and ORDINAL_POSITION.

Each column 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
COLUMN_NAME String => column name
DATA_TYPE int => SQL type from java.sql.Types
TYPE_NAME String => Data source dependent type name, for a UDT the type name is fully qualified
COLUMN_SIZE int => column size. For char or date types this is the maximum number of characters, for numeric or decimal types this is precision.
BUFFER_LENGTH is not used.
DECIMAL_DIGITS int => the number of fractional digits
NUM_PREC_RADIX int => Radix (typically either 10 or 2)
NULLABLE int => is NULL allowed.
columnNoNulls - might not allow NULL values
columnNullable - definitely allows NULL values
columnNullableUnknown - nullability unknown
REMARKS String => comment describing column (may be null)
COLUMN_DEF String => default value (may be null)
SQL_DATA_TYPE int => unused
SQL_DATETIME_SUB int => unused
CHAR_OCTET_LENGTH int => for char types the maximum number of bytes in the column
ORDINAL_POSITION int => index of column in table (starting at 1)
IS_NULLABLE String => "false" means column definitely does not allow NULL values; "true" means the column might allow NULL values. An empty string means nobody knows.
SCOPE_CATLOG String => catalog of table that is the scope of a reference attribute (null if DATA_TYPE isn't REF)
SCOPE_SCHEMA String => schema of table that is the scope of a reference attribute (null if the DATA_TYPE isn't REF)
SCOPE_TABLE String => table name that this the scope of a reference attribute (null if the DATA_TYPE isn't REF)
SOURCE_DATA_TYPE short => source type of a distinct type or user-generated Ref type, SQL type from java.sql.Types (null if DATA_TYPE isn't DISTINCT or user-generated REF)
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
columnNamePattern - a column name pattern; must match the column name as it is stored in the database

Returns:
ResultSet - each row is a column description

Throws:
SQLException - if a database access error occurs

JavaDatabaseMetaDataMBS.getConnection as JavaConnectionMBS

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

Retrieves the connection that produced this metadata object.

JavaDatabaseMetaDataMBS.getCrossReference(primaryCatalog as string, primarySchema as string, primaryTable as string, foreignCatalog as string, foreignSchema as string, foreignTable 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

Retrieves a description of the foreign key columns in the given foreign key table that reference the primary key columns of the given primary key table (describe how one table imports another's key).

This should normally return a single foreign key/primary key pair because most tables import a foreign key from a table only once. They are ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and KEY_SEQ.
Each foreign key column description has the following columns:

PKTABLE_CAT String => primary key table catalog (may be null)
PKTABLE_SCHEM String => primary key table schema (may be null)
PKTABLE_NAME String => primary key table name
PKCOLUMN_NAME String => primary key column name
FKTABLE_CAT String => foreign key table catalog (may be null) being exported (may be null)
FKTABLE_SCHEM String => foreign key table schema (may be null) being exported (may be null)
FKTABLE_NAME String => foreign key table name being exported
FKCOLUMN_NAME String => foreign key column name being exported
KEY_SEQ short => sequence number within foreign key
UPDATE_RULE short => What happens to foreign key when primary is updated:
importedNoAction - do not allow update of primary key if it has been imported
importedKeyCascade - change imported key to agree with primary key update
importedKeySetNull - change imported key to NULL if its primary key has been updated
importedKeySetDefault - change imported key to default values if its primary key has been updated
importedKeyRestrict - same as importedKeyNoAction (for ODBC 2.x compatibility)
DELETE_RULE short => What happens to the foreign key when primary is deleted.
importedKeyNoAction - do not allow delete of primary key if it has been imported
importedKeyCascade - delete rows that import a deleted key
importedKeySetNull - change imported key to NULL if its primary key has been deleted
importedKeyRestrict - same as importedKeyNoAction (for ODBC 2.x compatibility)
importedKeySetDefault - change imported key to default if its primary key has been deleted
FK_NAME String => foreign key name (may be null)
PK_NAME String => primary key name (may be null)
DEFERRABILITY short => can the evaluation of foreign key constraints be deferred until commit
importedKeyInitiallyDeferred - see SQL92 for definition
importedKeyInitiallyImmediate - see SQL92 for definition
importedKeyNotDeferrable - see SQL92 for definition
Parameters:
primaryCatalog - a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means drop catalog name from the selection criteria
primarySchema - a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means drop schema name from the selection criteria
primaryTable - the name of the table that exports the key; must match the table name as it is stored in the database
foreignCatalog - a catalog name; must match the catalog name as it is stored in the database; "" retrieves those without a catalog; null means drop catalog name from the selection criteria
foreignSchema - a schema name; must match the schema name as it is stored in the database; "" retrieves those without a schema; null means drop schema name from the selection criteria
foreignTable - the name of the table that imports the key; must match the table name as it is stored in the database
Returns:
ResultSet - each row is a foreign key column description
Throws:
SQLException - if a database access error occurs

JavaDatabaseMetaDataMBS.getDatabaseMajorVersion 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

Retrieves the major version number of the underlying database.

JavaDatabaseMetaDataMBS.getDatabaseMinorVersion 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

Retrieves the minor version number of the underlying database.

JavaDatabaseMetaDataMBS.getDatabaseProductName 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

Retrieves the name of this database product.

JavaDatabaseMetaDataMBS.getDatabaseProductVersion 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

Retrieves the version number of this database product.

JavaDatabaseMetaDataMBS.getDefaultTransactionIsolation 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

Retrieves this database's default transaction isolation level.

The possible values are defined in java.sql.Connection.

JavaDatabaseMetaDataMBS.getDriverMajorVersion 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

Retrieves this JDBC driver's major version number.

JavaDatabaseMetaDataMBS.getDriverMinorVersion 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

Retrieves this JDBC driver's minor version number.

JavaDatabaseMetaDataMBS.getDriverName 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

Retrieves the name of this JDBC driver.

JavaDatabaseMetaDataMBS.getDriverVersion 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

Retrieves the version number of this JDBC driver as a String.

JavaDatabaseMetaDataMBS.getExportedKeys(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

Retrieves a description of the foreign key columns that reference the given table's primary key columns (the foreign keys exported by a table).

They are ordered by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, and KEY_SEQ.
Each foreign key column description has the following columns:

PKTABLE_CAT String => primary key table catalog (may be null)
PKTABLE_SCHEM String => primary key table schema (may be null)
PKTABLE_NAME String => primary key table name
PKCOLUMN_NAME String => primary key column name
FKTABLE_CAT String => foreign key table catalog (may be null) being exported (may be null)
FKTABLE_SCHEM String => foreign key table schema (may be null) being exported (may be null)
FKTABLE_NAME String => foreign key table name being exported
FKCOLUMN_NAME String => foreign key column name being exported
KEY_SEQ short => sequence number within foreign key
UPDATE_RULE short => What happens to foreign key when primary is updated:
importedNoAction - do not allow update of primary key if it has been imported
importedKeyCascade - change imported key to agree with primary key update
importedKeySetNull - change imported key to NULL if its primary key has been updated
importedKeySetDefault - change imported key to default values if its primary key has been updated
importedKeyRestrict - same as importedKeyNoAction (for ODBC 2.x compatibility)
DELETE_RULE short => What happens to the foreign key when primary is deleted.
importedKeyNoAction - do not allow delete of primary key if it has been imported
importedKeyCascade - delete rows that import a deleted key
importedKeySetNull - change imported key to NULL if its primary key has been deleted
importedKeyRestrict - same as importedKeyNoAction (for ODBC 2.x compatibility)
importedKeySetDefault - change imported key to default if its primary key has been deleted
FK_NAME String => foreign key name (may be null)
PK_NAME String => primary key name (may be null)
DEFERRABILITY short => can the evaluation of foreign key constraints be deferred until commit
importedKeyInitiallyDeferred - see SQL92 for definition
importedKeyInitiallyImmediate - see SQL92 for definition
importedKeyNotDeferrable - see SQL92 for definition

Parameters:
catalog - a catalog name; must match the catalog name as it is stored in this 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 this database

Returns:
a ResultSet object in which each row is a foreign key column description

Throws:
SQLException - if a database access error occurs

JavaDatabaseMetaDataMBS.getExtraNameCharacters 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

Retrieves all the "extra" characters that can be used in unquoted identifier names (those beyond a-z, A-Z, 0-9 and _).

JavaDatabaseMetaDataMBS.getIdentifierQuoteString 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

Retrieves the string used to quote SQL identifiers. This method returns a space " " if identifier quoting is not supported.

JavaDatabaseMetaDataMBS.getImportedKeys(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

Retrieves a description of the primary key columns that are referenced by a table's foreign key columns (the primary keys imported by a table).

They are ordered by PKTABLE_CAT, PKTABLE_SCHEM, PKTABLE_NAME, and KEY_SEQ.
Each primary key column description has the following columns:

PKTABLE_CAT String => primary key table catalog being imported (may be null)
PKTABLE_SCHEM String => primary key table schema being imported (may be null)
PKTABLE_NAME String => primary key table name being imported
PKCOLUMN_NAME String => primary key column name being imported
FKTABLE_CAT String => foreign key table catalog (may be null)
FKTABLE_SCHEM String => foreign key table schema (may be null)
FKTABLE_NAME String => foreign key table name
FKCOLUMN_NAME String => foreign key column name
KEY_SEQ short => sequence number within a foreign key
UPDATE_RULE short => What happens to a foreign key when the primary key is updated:
importedNoAction - do not allow update of primary key if it has been imported
importedKeyCascade - change imported key to agree with primary key update
importedKeySetNull - change imported key to NULL if its primary key has been updated
importedKeySetDefault - change imported key to default values if its primary key has been updated
importedKeyRestrict - same as importedKeyNoAction (for ODBC 2.x compatibility)
DELETE_RULE short => What happens to the foreign key when primary is deleted.
importedKeyNoAction - do not allow delete of primary key if it has been imported
importedKeyCascade - delete rows that import a deleted key
importedKeySetNull - change imported key to NULL if its primary key has been deleted
importedKeyRestrict - same as importedKeyNoAction (for ODBC 2.x compatibility)
importedKeySetDefault - change imported key to default if its primary key has been deleted
FK_NAME String => foreign key name (may be null)
PK_NAME String => primary key name (may be null)
DEFERRABILITY short => can the evaluation of foreign key constraints be deferred until commit
importedKeyInitiallyDeferred - see SQL92 for definition
importedKeyInitiallyImmediate - see SQL92 for definition
importedKeyNotDeferrable - see SQL92 for definition
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:
ResultSet - each row is a primary key column description

Throws:
SQLException - if a database access error occurs

JavaDatabaseMetaDataMBS.getJDBCMajorVersion 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

Retrieves the major JDBC version number for this driver.

JavaDatabaseMetaDataMBS.getJDBCMinorVersion 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

Retrieves the minor JDBC version number for this driver.

JavaDatabaseMetaDataMBS.getMaxBinaryLiteralLength 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

Retrieves the maximum number of hex characters this database allows in an inline binary literal.

Returns the maximum length (in hex characters) for a binary literal; a result of zero means that there is no limit or the limit is not known

JavaDatabaseMetaDataMBS.getMaxCatalogNameLength 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

Retrieves the maximum number of characters that this database allows in a catalog name.

Returns the maximum number of characters allowed in a catalog name; a result of zero means that there is no limit or the limit is not known

JavaDatabaseMetaDataMBS.getMaxCharLiteralLength 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

Retrieves the maximum number of characters this database allows for a character literal.

Returns the maximum number of characters allowed for a character literal; a result of zero means that there is no limit or the limit is not known

JavaDatabaseMetaDataMBS.getMaxColumnNameLength 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

Retrieves the maximum number of characters this database allows for a column name.

Returns the maximum number of characters allowed for a column name; a result of zero means that there is no limit or the limit is not known

JavaDatabaseMetaDataMBS.getMaxColumnsInGroupBy 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

Retrieves the maximum number of columns this database allows in a GROUP BY clause.

Returns the maximum number of columns allowed; a result of zero means that there is no limit or the limit is not known

JavaDatabaseMetaDataMBS.getMaxColumnsInIndex 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

Retrieves the maximum number of columns this database allows in an index.

Returns the maximum number of columns allowed; a result of zero means that there is no limit or the limit is not known

JavaDatabaseMetaDataMBS.getMaxColumnsInOrderBy 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

Retrieves the maximum number of columns this database allows in an ORDER BY clause.

Returns the maximum number of columns allowed; a result of zero means that there is no limit or the limit is not known

JavaDatabaseMetaDataMBS.getMaxColumnsInSelect 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

Retrieves the maximum number of columns this database allows in a SELECT list.

Returns the maximum number of columns allowed; a result of zero means that there is no limit or the limit is not known

JavaDatabaseMetaDataMBS.getMaxColumnsInTable 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

Retrieves the maximum number of columns this database allows in a table.

Returns the maximum number of columns allowed; a result of zero means that there is no limit or the limit is not known

JavaDatabaseMetaDataMBS.getMaxConnections 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

Retrieves the maximum number of concurrent connections to this database that are possible.

Returns the maximum number of active connections possible at one time; a result of zero means that there is no limit or the limit is not known

JavaDatabaseMetaDataMBS.getMaxCursorNameLength 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

Retrieves the maximum number of characters that this database allows in a cursor name.

Returns the maximum number of characters allowed in a cursor name; a result of zero means that there is no limit or the limit is not known