Platforms to show: All Mac Windows Linux Cross-Platform

Back to JavaDatabaseMetaDataMBS class.

Next items

JavaDatabaseMetaDataMBS.allProceduresAreCallable 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 the current user can call all the procedures returned by the method getProcedures.

Returns true if so; false otherwise

JavaDatabaseMetaDataMBS.allTablesAreSelectable 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 the current user can use all the tables returned by the method getTables in a SELECT statement.

Returns true if so; false otherwise

JavaDatabaseMetaDataMBS.attributeNoNulls 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 NULL values might not be allowed.

A possible value for the column NULLABLE in the ResultSet object returned by the method getAttributes.

JavaDatabaseMetaDataMBS.attributeNullable 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 NULL values are definitely allowed.

A possible value for the column NULLABLE in the ResultSet object returned by the method getAttributes.

JavaDatabaseMetaDataMBS.attributeNullableUnknown 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 whether NULL values are allowed is not known.

A possible value for the column NULLABLE in the ResultSet object returned by the method getAttributes.

JavaDatabaseMetaDataMBS.bestRowNotPseudo 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 best row identifier is NOT a pseudo column.

A possible value for the column PSEUDO_COLUMN in the ResultSet object returned by the method getBestRowIdentifier.

JavaDatabaseMetaDataMBS.bestRowPseudo 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 best row identifier is a pseudo column.

A possible value for the column PSEUDO_COLUMN in the ResultSet object returned by the method getBestRowIdentifier.

JavaDatabaseMetaDataMBS.bestRowSession 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 scope of the best row identifier is the remainder of the current session.

A possible value for the column SCOPE in the ResultSet object returned by the method getBestRowIdentifier.

JavaDatabaseMetaDataMBS.bestRowTemporary 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 scope of the best row identifier is very temporary, lasting only while the row is being used.

A possible value for the column SCOPE in the ResultSet object returned by the method getBestRowIdentifier.

JavaDatabaseMetaDataMBS.bestRowTransaction 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 scope of the best row identifier is the remainder of the current transaction.

A possible value for the column SCOPE in the ResultSet object returned by the method getBestRowIdentifier.

JavaDatabaseMetaDataMBS.bestRowUnknown 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 best row identifier may or may not be a pseudo column.

A possible value for the column PSEUDO_COLUMN in the ResultSet object returned by the method getBestRowIdentifier.

JavaDatabaseMetaDataMBS.columnNoNulls 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 column might not allow NULL values.

A possible value for the column NULLABLE in the ResultSet returned by the method getColumns.

JavaDatabaseMetaDataMBS.columnNullable 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 column definitely allows NULL values.

A possible value for the column NULLABLE in the ResultSet returned by the method getColumns.

JavaDatabaseMetaDataMBS.columnNullableUnknown 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 nullability of columns is unknown.

A possible value for the column NULLABLE in the ResultSet returned by the method getColumns.

JavaDatabaseMetaDataMBS.Constructor   Private

Type Topic Plugin Version macOS Windows Linux iOS Targets
method Java Database MBS Java Plugin 15.1 ✅ Yes ✅ Yes ✅ Yes ❌ No Desktop, Console & Web
The private constructor.

JavaDatabaseMetaDataMBS.dataDefinitionCausesTransactionCommit 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 data definition statement within a transaction forces the transaction to commit.

JavaDatabaseMetaDataMBS.dataDefinitionIgnoredInTransactions 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 ignores a data definition statement within a transaction.

JavaDatabaseMetaDataMBS.deletesAreDetected(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
Retrieves whether or not a visible row delete can be detected by calling the method ResultSet.rowDeleted.

If the method deletesAreDetected returns false, it means that deleted rows are removed from the result set.

Parameters:
type - the ResultSet type; one of ResultSet.TYPE_FORWARD_ONLY, ResultSet.TYPE_SCROLL_INSENSITIVE, or ResultSet.TYPE_SCROLL_SENSITIVE

Returns:
true if deletes are detected by the given result set type; false otherwise

JavaDatabaseMetaDataMBS.doesMaxRowSizeIncludeBlobs 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 the return value for the method getMaxRowSize includes the SQL data types LONGVARCHAR and LONGVARBINARY.

Returns true if so; false otherwise.

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 attribure (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 _).

Next items

The items on this page are in the following plugins: MBS Java Plugin.


The biggest plugin in space...