Platforms to show: All Mac Windows Linux Cross-Platform
JavaDatabaseMetaDataMBS class
Super class: JavaObjectMBS
Type | Topic | Plugin | Version | macOS | Windows | Linux | iOS | Targets |
class | Java Database | MBS Java Plugin | 8.5 | ✅ Yes | ✅ Yes | ✅ Yes | ❌ No | Desktop, Console & Web |
This interface is implemented by driver vendors to let users know the capabilities of a Database Management System (DBMS) in combination with the driver based on JDBCTM technology ("JDBC driver") that is used with it. Different relational DBMSs often support different features, implement features in different ways, and use different data types. In addition, a driver may implement a feature on top of what the DBMS offers. Information returned by methods in this interface applies to the capabilities of a particular driver and a particular DBMS working together. Note that as used in this documentation, the term "database" is used generically to refer to both the driver and DBMS.
A user for this interface is commonly a tool that needs to discover how to deal with the underlying DBMS. This is especially true for applications that are intended to be used with more than one DBMS. For example, a tool might use the method getTypeInfo to find out what data types can be used in a CREATE TABLE statement. Or a user might call the method supportsCorrelatedSubqueries to see if it is possible to use a correlated subquery or supportsBatchUpdates to see if it is possible to use batch updates.
Some DatabaseMetaData methods return lists of information in the form of ResultSet objects. Regular ResultSet methods, such as getString and getInt, can be used to retrieve the data from these ResultSet objects. If a given form of metadata is not available, the ResultSet getter methods throw an SQLException.
Some DatabaseMetaData methods take arguments that are String patterns. These arguments all have names such as fooPattern. Within a pattern String, "%" means match any substring of 0 or more characters, and "_" means match any one character. Only metadata entries matching the search pattern are returned. If a search pattern argument is set to null, that argument's criterion will be dropped from the search.
A method that gets information about a feature that the driver does not support will throw an SQLException. In the case of methods that return a ResultSet object, either a ResultSet object (which may be empty) is returned or an SQLException is thrown.
Subclass of the JavaObjectMBS class.
This is an abstract class. You can't create an instance, but you can get one from various plugin functions.
- 212 methods
- method allProceduresAreCallable as boolean
- method allTablesAreSelectable as boolean
- method attributeNoNulls as Integer
- method attributeNullable as Integer
- method attributeNullableUnknown as Integer
- method bestRowNotPseudo as Integer
- method bestRowPseudo as Integer
- method bestRowSession as Integer
- method bestRowTemporary as Integer
- method bestRowTransaction as Integer
- method bestRowUnknown as Integer
- method columnNoNulls as Integer
- method columnNullable as Integer
- method columnNullableUnknown as Integer
- method Constructor Private
- method dataDefinitionCausesTransactionCommit as boolean
- method dataDefinitionIgnoredInTransactions as boolean
- method deletesAreDetected(type as Integer) as boolean
- method doesMaxRowSizeIncludeBlobs as boolean
- method getAttributes(catalog as string, schemaPattern as string, typeNamePattern as string, attributeNamePattern as string) as JavaResultSetMBS
- method getCatalogs as JavaResultSetMBS
- method getCatalogSeparator as string
- method getCatalogTerm as string
- method getColumnPrivileges(catalog as string, schema as string, table as string, columnNamePattern as string) as JavaResultSetMBS
- method getColumns(catalog as string, schemaPattern as string, tableNamePattern as string, columnNamePattern as string) as JavaResultSetMBS
- method getConnection as JavaConnectionMBS
- method getCrossReference(primaryCatalog as string, primarySchema as string, primaryTable as string, foreignCatalog as string, foreignSchema as string, foreignTable as string) as JavaResultSetMBS
- method getDatabaseMajorVersion as Integer
- method getDatabaseMinorVersion as Integer
- method getDatabaseProductName as string
- method getDatabaseProductVersion as string
- method getDefaultTransactionIsolation as Integer
- method getDriverMajorVersion as Integer
- method getDriverMinorVersion as Integer
- method getDriverName as string
- method getDriverVersion as string
- method getExportedKeys(catalog as string, schema as string, table as string) as JavaResultSetMBS
- method getExtraNameCharacters as string
- method getIdentifierQuoteString as string
- method getImportedKeys(catalog as string, schema as string, table as string) as JavaResultSetMBS
- method getJDBCMajorVersion as Integer
- method getJDBCMinorVersion as Integer
- method getMaxBinaryLiteralLength as Integer
- method getMaxCatalogNameLength as Integer
- method getMaxCharLiteralLength as Integer
- method getMaxColumnNameLength as Integer
- method getMaxColumnsInGroupBy as Integer
- method getMaxColumnsInIndex as Integer
- method getMaxColumnsInOrderBy as Integer
- method getMaxColumnsInSelect as Integer
- method getMaxColumnsInTable as Integer
- method getMaxConnections as Integer
- method getMaxCursorNameLength as Integer
- method getMaxIndexLength as Integer
- method getMaxProcedureNameLength as Integer
- method getMaxRowSize as Integer
- method getMaxSchemaNameLength as Integer
- method getMaxStatementLength as Integer
- method getMaxStatements as Integer
- method getMaxTableNameLength as Integer
- method getMaxTablesInSelect as Integer
- method getMaxUserNameLength as Integer
- method getNumericFunctions as string
- method getPrimaryKeys(catalog as string, schema as string, table as string) as JavaResultSetMBS
- method getProcedureColumns(catalog as string, schemaPattern as string, procedureNamePattern as string, columnNamePattern as string) as JavaResultSetMBS
- method getProcedures(catalog as string, schemaPattern as string, procedureNamePattern as string) as JavaResultSetMBS
- method getProcedureTerm as string
- method getResultSetHoldability as Integer
- method getSchemas as JavaResultSetMBS
- method getSchemaTerm as string
- method getSearchStringEscape as string
- method getSQLKeywords as string
- method getSQLStateType as Integer
- method getStringFunctions as string
- method getSuperTables(catalog as string, schemaPattern as string, tableNamePattern as string) as JavaResultSetMBS
- method getSuperTypes(catalog as string, schemaPattern as string, typeNamePattern as string) as JavaResultSetMBS
- method getSystemFunctions as string
- method getTablePrivileges(catalog as string, schemaPattern as string, tableNamePattern as string) as JavaResultSetMBS
- method getTables(catalog as string, schemaPattern as string, tableNamePattern as string) as JavaResultSetMBS
- method getTables(catalog as string, schemaPattern as string, tableNamePattern as string, types() as string) as JavaResultSetMBS
- method getTableTypes as JavaResultSetMBS
- method getTimeDateFunctions as string
- method getTypeInfos as JavaResultSetMBS
- method getURL as string
- method getUserName as string
- method getVersionColumns(catalog as string, schema as string, table as string) as JavaResultSetMBS
- method importedKeyCascade as Integer
- method importedKeyInitiallyDeferred as Integer
- method importedKeyInitiallyImmediate as Integer
- method importedKeyNoAction as Integer
- method importedKeyNotDeferrable as Integer
- method importedKeyRestrict as Integer
- method importedKeySetDefault as Integer
- method importedKeySetNull as Integer
- method insertsAreDetected(type as Integer) as boolean
- method isCatalogAtStart as boolean
- method isReadOnly as boolean
- method locatorsUpdateCopy as boolean
- method nullPlusNonNullIsNull as boolean
- method nullsAreSortedAtEnd as boolean
- method nullsAreSortedAtStart as boolean
- method nullsAreSortedHigh as boolean
- method nullsAreSortedLow as boolean
- method othersDeletesAreVisible(type as Integer) as boolean
- method othersInsertsAreVisible(type as Integer) as boolean
- method othersUpdatesAreVisible(type as Integer) as boolean
- method ownDeletesAreVisible(type as Integer) as boolean
- method ownInsertsAreVisible(type as Integer) as boolean
- method ownUpdatesAreVisible(type as Integer) as boolean
- method procedureColumnIn as Integer
- method procedureColumnInOut as Integer
- method procedureColumnOut as Integer
- method procedureColumnResult as Integer
- method procedureColumnReturn as Integer
- method procedureColumnUnknown as Integer
- method procedureNoNulls as Integer
- method procedureNoResult as Integer
- method procedureNullable as Integer
- method procedureNullableUnknown as Integer
- method procedureResultUnknown as Integer
- method procedureReturnsResult as Integer
- method sqlStateSQL99 as Integer
- method sqlStateXOpen as Integer
- method storesLowerCaseIdentifiers as boolean
- method storesLowerCaseQuotedIdentifiers as boolean
- method storesMixedCaseIdentifiers as boolean
- method storesMixedCaseQuotedIdentifiers as boolean
- method storesUpperCaseIdentifiers as boolean
- method storesUpperCaseQuotedIdentifiers as boolean
- method supportsAlterTableWithAddColumn as boolean
- method supportsAlterTableWithDropColumn as boolean
- method supportsANSI92EntryLevelSQL as boolean
- method supportsANSI92FullSQL as boolean
- method supportsANSI92IntermediateSQL as boolean
- method supportsBatchUpdates as boolean
- method supportsCatalogsInDataManipulation as boolean
- method supportsCatalogsInIndexDefinitions as boolean
- method supportsCatalogsInPrivilegeDefinitions as boolean
- method supportsCatalogsInProcedureCalls as boolean
- method supportsCatalogsInTableDefinitions as boolean
- method supportsColumnAliasing as boolean
- method supportsConvert as boolean
- method supportsConvert(fromType as Integer, toType as Integer) as boolean
- method supportsCoreSQLGrammar as boolean
- method supportsCorrelatedSubqueries as boolean
- method supportsDataDefinitionAndDataManipulationTransactions as boolean
- method supportsDataManipulationTransactionsOnly as boolean
- method supportsDifferentTableCorrelationNames as boolean
- method supportsExpressionsInOrderBy as boolean
- method supportsExtendedSQLGrammar as boolean
- method supportsFullOuterJoins as boolean
- method supportsGetGeneratedKeys as boolean
- method supportsGroupBy as boolean
- method supportsGroupByBeyondSelect as boolean
- method supportsGroupByUnrelated as boolean
- method supportsIntegrityEnhancementFacility as boolean
- method supportsLikeEscapeClause as boolean
- method supportsLimitedOuterJoins as boolean
- method supportsMinimumSQLGrammar as boolean
- method supportsMixedCaseIdentifiers as boolean
- method supportsMixedCaseQuotedIdentifiers as boolean
- method supportsMultipleOpenResults as boolean
- method supportsMultipleResultSets as boolean
- method supportsMultipleTransactions as boolean
- method supportsNamedParameters as boolean
- method supportsNonNullableColumns as boolean
- method supportsOpenCursorsAcrossCommit as boolean
- method supportsOpenCursorsAcrossRollback as boolean
- method supportsOpenStatementsAcrossCommit as boolean
- method supportsOpenStatementsAcrossRollback as boolean
- method supportsOrderByUnrelated as boolean
- method supportsOuterJoins as boolean
- method supportsPositionedDelete as boolean
- method supportsPositionedUpdate as boolean
- method supportsResultSetConcurrency(type as Integer, concurrency as Integer) as boolean
- method supportsResultSetHoldability(holdability as Integer) as boolean
- method supportsResultSetType(type as Integer) as boolean
- method supportsSavepoints as boolean
- method supportsSchemasInDataManipulation as boolean
- method supportsSchemasInIndexDefinitions as boolean
- method supportsSchemasInPrivilegeDefinitions as boolean
- method supportsSchemasInProcedureCalls as boolean
- method supportsSchemasInTableDefinitions as boolean
- method supportsSelectForUpdate as boolean
- method supportsStatementPooling as boolean
- method supportsStoredProcedures as boolean
- method supportsSubqueriesInComparisons as boolean
- method supportsSubqueriesInExists as boolean
- method supportsSubqueriesInIns as boolean
- method supportsSubqueriesInQuantifieds as boolean
- method supportsTableCorrelationNames as boolean
- method supportsTransactionIsolationLevel(level as Integer) as boolean
- method supportsTransactions as boolean
- method supportsUnion as boolean
- method supportsUnionAll as boolean
- method tableIndexClustered as Integer
- method tableIndexHashed as Integer
- method tableIndexOther as Integer
- method tableIndexStatistic as Integer
- method typeNoNulls as Integer
- method typeNullable as Integer
- method typeNullableUnknown as Integer
- method typePredBasic as Integer
- method typePredChar as Integer
- method typePredNone as Integer
- method typeSearchable as Integer
- method updatesAreDetected(type as Integer) as boolean
- method usesLocalFilePerTable as boolean
- method usesLocalFiles as boolean
- method versionColumnNotPseudo as Integer
- method versionColumnPseudo as Integer
- method versionColumnUnknown as Integer
Super class JavaObjectMBS
- 16 properties
- property ClassName as String
- property Database as Variant
- property Handle as Integer
- property Lasterror as Integer
- property Tag as Variant
- property VM as JavaVMMBS
- property BooleanField(TheField as JavaFieldMBS) as boolean
- property ByteField(TheField as JavaFieldMBS) as Integer
- property CharField(TheField as JavaFieldMBS) as Integer
- property DoubleField(TheField as JavaFieldMBS) as Double
- property Field(TheField as JavaFieldMBS) as Variant
- property FloatField(TheField as JavaFieldMBS) as single
- property IntField(TheField as JavaFieldMBS) as Integer
- property LongField(TheField as JavaFieldMBS) as Int64
- property ObjectField(TheField as JavaFieldMBS) as JavaObjectMBS
- property ShortField(TheField as JavaFieldMBS) as Integer
- 28 methods
- method CallBooleanMethod(MethodID as JavaMethodMBS, args as memoryblock) as boolean
- method CallByteMethod(MethodID as JavaMethodMBS, args as memoryblock) as Integer
- method CallCharMethod(MethodID as JavaMethodMBS, args as memoryblock) as Integer
- method CallDoubleMethod(MethodID as JavaMethodMBS, args as memoryblock) as Double
- method CallFloatMethod(MethodID as JavaMethodMBS, args as memoryblock) as single
- method CallIntMethod(MethodID as JavaMethodMBS, args as memoryblock) as Integer
- method CallLongMethod(MethodID as JavaMethodMBS, args as memoryblock) as Int64
- method CallMethod(MethodID as JavaMethodMBS, args() as Variant) as Variant
- method CallNonvirtualBooleanMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock) as boolean
- method CallNonvirtualByteMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock) as Integer
- method CallNonvirtualCharMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock) as Integer
- method CallNonvirtualDoubleMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock) as Double
- method CallNonvirtualFloatMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock) as single
- method CallNonvirtualIntMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock) as Integer
- method CallNonvirtualLongMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock) as Int64
- method CallNonvirtualMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args() as Variant) as Variant
- method CallNonvirtualObjectMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock) as JavaObjectMBS
- method CallNonvirtualShortMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock) as Integer
- method CallNonvirtualVoidMethod(TheClass as JavaClassMBS, MethodID as JavaMethodMBS, args as memoryblock)
- method CallObjectMethod(MethodID as JavaMethodMBS, args as memoryblock) as JavaObjectMBS
- method CallShortMethod(MethodID as JavaMethodMBS, args as memoryblock) as Integer
- method CallVoidMethod(MethodID as JavaMethodMBS, args as memoryblock)
- method Constructor Private
- method GetDirectBufferAddress(directbuffer as JavaObjectMBS) as Integer
- method GetDirectBufferCapacity(directbuffer as JavaObjectMBS) as Integer
- method IsInstanceOf(TheClass as JavaClassMBS) as boolean
- method IsSameObject(obj as JavaObjectMBS) as boolean
- method ObjectClass as JavaClassMBS
This class has no sub classes.
Some methods using this class:
- JavaConnectionMBS.getMetaData as JavaDatabaseMetaDataMBS
The items on this page are in the following plugins: MBS Java Plugin.
JavaDatabaseMBS - JavaDoubleArrayMBS