boolean | allProceduresAreCallable()- This method tests whether or not all the procedures returned by
the
getProcedures method can be called by this user.
|
boolean | allTablesAreSelectable()- This method tests whether or not all the table returned by the
getTables method can be selected by this user.
|
boolean | dataDefinitionCausesTransactionCommit()- This method tests whether or not a DDL statement will cause the
current transaction to be automatically committed.
|
boolean | dataDefinitionIgnoredInTransactions()- This method tests whether or not DDL statements are ignored in
transactions.
|
boolean | deletesAreDetected(int type)- This method tests whether or not the specified result set type can detect
a visible delete by calling the
rowUpdated method.
|
boolean | doesMaxRowSizeIncludeBlobs()- This method tests whether or not the maximum row size includes BLOB's
|
ResultSet | getAttributes(String catalog, String schemaPattern, String typePattern, String attributePattern)
|
ResultSet | getBestRowIdentifier(String catalog, String schema, String tableName, int scope, boolean nullable)- This method returns the best set of columns for uniquely identifying
a row.
|
String | getCatalogSeparator()- This method returns the separator between the catalog name and the
table name.
|
String | getCatalogTerm()- This method returns the vendor's term for "catalog".
|
ResultSet | getCatalogs()- This method returns the list of database catalogs as a
ResultSet with one column - TABLE_CAT - that is the
name of the catalog.
|
ResultSet | getColumnPrivileges(String catalog, String schema, String tableName, String columnPattern)- This method returns the access rights that have been granted to the
requested columns.
|
ResultSet | getColumns(String catalog, String schemaPattern, String tablePattern, String columnPattern)- This method returns a list of the tables columns for
the requested tables.
|
Connection | getConnection()- This method returns the
Connection object that was used
to generate the metadata in this object.
|
ResultSet | getCrossReference(String primaryCatalog, String primarySchema, String primaryTableName, String foreignCatalog, String foreignSchema, String foreignTableName)- This method returns a description of how one table imports another
table's primary key as a foreign key.
|
int | getDatabaseMajorVersion()- This method returns the major version number of the database.
|
int | getDatabaseMinorVersion()- This method returns the minor version number of the database.
|
String | getDatabaseProductName()- This method returns the name of the database product.
|
String | getDatabaseProductVersion()- This method returns the version of the database product.
|
int | getDefaultTransactionIsolation()- This method returns the default transaction isolation level of the
database.
|
int | getDriverMajorVersion()- This method returns the major version number of the JDBC driver.
|
int | getDriverMinorVersion()- This method returns the minor version number of the JDBC driver.
|
String | getDriverName()- This method returns the name of the JDBC driver.
|
String | getDriverVersion()- This method returns the version of the JDBC driver.
|
ResultSet | getExportedKeys(String catalog, String schema, String tableName)- This method returns a list of the table's which use this table's
primary key as a foreign key.
|
String | getExtraNameCharacters()- This methods returns non-standard characters that can appear in
unquoted identifiers.
|
String | getIdentifierQuoteString()- This metohd returns the quote string for SQL identifiers.
|
ResultSet | getImportedKeys(String catalog, String schema, String tableName)- This method returns a list of the table's foreign keys.
|
ResultSet | getIndexInfo(String catalog, String schema, String tableName, boolean unique, boolean approximate)- This method returns information about a tables indices and statistics.
|
int | getJDBCMajorVersion()- This method returns the major version number of the JDBC driver.
|
int | getJDBCMinorVersion()- This method returns the minor version number of the JDBC driver.
|
int | getMaxBinaryLiteralLength()- This method returns the number of hex characters allowed in an inline
binary literal.
|
int | getMaxCatalogNameLength()- This method returns the maximum length of a catalog name.
|
int | getMaxCharLiteralLength()- This method returns the maximum length of a character literal.
|
int | getMaxColumnNameLength()- This method returns the maximum length of a column name.
|
int | getMaxColumnsInGroupBy()- This method returns the maximum number of columns in a GROUP BY statement.
|
int | getMaxColumnsInIndex()- This method returns the maximum number of columns in an index.
|
int | getMaxColumnsInOrderBy()- This method returns the maximum number of columns in an ORDER BY statement.
|
int | getMaxColumnsInSelect()- This method returns the maximum number of columns in a SELECT statement.
|
int | getMaxColumnsInTable()- This method returns the maximum number of columns in a table.
|
int | getMaxConnections()- This method returns the maximum number of connections this client
can have to the database.
|
int | getMaxCursorNameLength()- This method returns the maximum length of a cursor name.
|
int | getMaxIndexLength()- This method returns the maximum length of an index.
|
int | getMaxProcedureNameLength()- This method returns the maximum length of a procedure name.
|
int | getMaxRowSize()- This method returns the maximum size of a row in bytes.
|
int | getMaxSchemaNameLength()- This method returns the maximum length of a schema name.
|
int | getMaxStatementLength()- This method includes the maximum length of a SQL statement.
|
int | getMaxStatements()- This method returns the maximum number of statements that can be
active at any time.
|
int | getMaxTableNameLength()- This method returns the maximum length of a table name.
|
int | getMaxTablesInSelect()- This method returns the maximum number of tables that may be referenced
in a SELECT statement.
|
int | getMaxUserNameLength()- This method returns the maximum length of a user name.
|
String | getNumericFunctions()- This method returns a comma separated list of math functions.
|
ResultSet | getPrimaryKeys(String catalog, String schema, String tableName)- This method returns a list of a table's primary key columns.
|
ResultSet | getProcedureColumns(String catalog, String schemaPattern, String procedurePattern, String columnPattern)- This method returns a list of the parameter and result columns for
the requested stored procedures.
|
String | getProcedureTerm()- This method returns the vendor's term for "procedure".
|
ResultSet | getProcedures(String catalog, String schemaPattern, String procedurePattern)- This method returns a list of all the stored procedures matching the
specified pattern in the given schema and catalog.
|
int | getResultSetHoldability()- This method returns the default holdability type of
ResultSetS
retrieved from this database.
|
String | getSQLKeywords()- This method returns a comma separated list of all the SQL keywords in
the database that are not in SQL92.
|
int | getSQLStateType()
|
String | getSchemaTerm()- This method returns the vendor's term for "schema".
|
ResultSet | getSchemas()- This method returns the list of database schemas as a
ResultSet, with one column - TABLE_SCHEM - that is the
name of the schema.
|
String | getSearchStringEscape()- This method returns the string used to escape wildcards in search strings.
|
String | getStringFunctions()- This method returns a comma separated list of string functions.
|
ResultSet | getSuperTables(String catalog, String schemaPattern, String tablePattern)
|
ResultSet | getSuperTypes(String catalog, String schemaPattern, String typePattern)
|
String | getSystemFunctions()- This method returns a comma separated list of of system functions.
|
ResultSet | getTablePrivileges(String catalog, String schemaPattern, String tablePattern)- This method returns the access rights that have been granted to the
requested tables.
|
ResultSet | getTableTypes()- This method returns the list of database table types as a
ResultSet with one column - TABLE_TYPE - that is the
name of the table type.
|
ResultSet | getTables(String catalog, String schemaPattern, String tablePattern, String[] types)- This method returns a list of the requested table as a
ResultSet with the following columns:
- TABLE_CAT - The catalog the table is in, which may be
null. - TABLE_SCHEM - The schema the table is in, which may be
null. - TABLE_NAME - The name of the table.
- TABLE_TYPE - A string describing the table type.
|
String | getTimeDateFunctions()- This method returns comma separated list of time/date functions.
|
ResultSet | getTypeInfo()- This method returns a list of the SQL types supported by this
database.
|
ResultSet | getUDTs(String catalog, String schemaPattern, String typePattern, int[] types)- This method returns the list of user defined data types in use.
|
String | getURL()- This method returns the URL for this database.
|
String | getUserName()- This method returns the database username for this connection.
|
ResultSet | getVersionColumns(String catalog, String schema, String tableName)- This method returns the set of columns that are automatically updated
when the row is update.
|
boolean | insertsAreDetected(int type)- This method tests whether or not the specified result set type can detect
a visible insert by calling the
rowUpdated method.
|
boolean | isCatalogAtStart()- This method tests whether a catalog name appears at the beginning of
a fully qualified table name.
|
boolean | isReadOnly()- This method tests whether or not the database is in read only mode.
|
boolean | locatorsUpdateCopy()
|
boolean | nullPlusNonNullIsNull()- This method tests whether the concatenation of a NULL and non-NULL
value results in a NULL.
|
boolean | nullsAreSortedAtEnd()- This method test whether or not NULL's are sorted to the end
of the list regardless of ascending or descending sort order.
|
boolean | nullsAreSortedAtStart()- This method tests whether or not NULL's sort as high values.
|
boolean | nullsAreSortedHigh()- This method tests whether or not NULL's sort as high values.
|
boolean | nullsAreSortedLow()- This method tests whether or not NULL's sort as low values.
|
boolean | othersDeletesAreVisible(int type)- This method tests whether or not the specified result set type sees
deletes committed by others.
|
boolean | othersInsertsAreVisible(int type)- This method tests whether or not the specified result set type sees
inserts committed by others.
|
boolean | othersUpdatesAreVisible(int type)- This method tests whether or not the specified result set type sees
updates committed by others.
|
boolean | ownDeletesAreVisible(int type)- This method tests whether or not the specified result set type sees its
own deletes.
|
boolean | ownInsertsAreVisible(int type)- This method tests whether or not the specified result set type sees its
own inserts.
|
boolean | ownUpdatesAreVisible(int type)- This method tests whether or not the specified result set type sees its
own updates.
|
boolean | storesLowerCaseIdentifiers()- This method tests whether or not the database treats mixed case
identifiers as all lower case.
|
boolean | storesLowerCaseQuotedIdentifiers()- This method tests whether or not the database treats mixed case
quoted identifiers as all lower case.
|
boolean | storesMixedCaseIdentifiers()- This method tests whether or not the database stores mixed case
identifers even if it treats them as case insensitive.
|
boolean | storesMixedCaseQuotedIdentifiers()- This method tests whether or not the database stores mixed case
quoted identifers even if it treats them as case insensitive.
|
boolean | storesUpperCaseIdentifiers()- This method tests whether or not the database treats mixed case
identifiers as all upper case.
|
boolean | storesUpperCaseQuotedIdentifiers()- This method tests whether or not the database treats mixed case
quoted identifiers as all upper case.
|
boolean | supportsANSI92EntryLevelSQL()- This method tests whether or not the ANSI92 entry level SQL
grammar is supported.
|
boolean | supportsANSI92FullSQL()- This method tests whether or not the ANSI92 full SQL
grammar is supported.
|
boolean | supportsANSI92IntermediateSQL()- This method tests whether or not the ANSI92 intermediate SQL
grammar is supported.
|
boolean | supportsAlterTableWithAddColumn()- This method tests whether or not the database supports
"ALTER TABLE ADD COLUMN"
|
boolean | supportsAlterTableWithDropColumn()- This method tests whether or not the database supports
"ALTER TABLE DROP COLUMN"
|
boolean | supportsBatchUpdates()- This method tests whether or not the database supports batch updates.
|
boolean | supportsCatalogsInDataManipulation()- This method tests whether a catalog name can appear in a data
manipulation statement.
|
boolean | supportsCatalogsInIndexDefinitions()- This method tests whether a catalog name can appear in an index definition.
|
boolean | supportsCatalogsInPrivilegeDefinitions()- This method tests whether a catalog name can appear in privilege definitions.
|
boolean | supportsCatalogsInProcedureCalls()- This method tests whether a catalog name can appear in a procedure
call
|
boolean | supportsCatalogsInTableDefinitions()- This method tests whether a catalog name can appear in a table definition.
|
boolean | supportsColumnAliasing()- This method tests whether or not column aliasing is supported.
|
boolean | supportsConvert()- Tests whether or not CONVERT is supported.
|
boolean | supportsConvert(int fromType, int toType)- This method tests whether or not CONVERT can be performed between the
specified types.
|
boolean | supportsCoreSQLGrammar()- This method tests whether or not the core grammer for ODBC is supported.
|
boolean | supportsCorrelatedSubqueries()- This method test whether or not correlated subqueries are allowed.
|
boolean | supportsDataDefinitionAndDataManipulationTransactions()- This method tests whether or not DDL and DML statements allowed within
the same transaction.
|
boolean | supportsDataManipulationTransactionsOnly()- This method tests whether or not only DML statement are allowed
inside a transaction.
|
boolean | supportsDifferentTableCorrelationNames()- This method tests whether correlation names must be different from the
name of the table.
|
boolean | supportsExpressionsInOrderBy()- This method tests whether or not expressions are allowed in an
ORDER BY lists.
|
boolean | supportsExtendedSQLGrammar()- This method tests whether or not the extended grammer for ODBC is supported.
|
boolean | supportsFullOuterJoins()- This method tests whether or not the database supports full outer joins.
|
boolean | supportsGetGeneratedKeys()
|
boolean | supportsGroupBy()- This method tests whether or not GROUP BY is supported.
|
boolean | supportsGroupByBeyondSelect()- This method tests whether or not a GROUP BY can add columns not in the
select if it includes all the columns in the select.
|
boolean | supportsGroupByUnrelated()- This method tests whether GROUP BY on a non-selected column is
allowed.
|
boolean | supportsIntegrityEnhancementFacility()- This method tests whether or not the SQL integrity enhancement
facility is supported.
|
boolean | supportsLikeEscapeClause()- This method tests whether or not the escape character is supported in
LIKE expressions.
|
boolean | supportsLimitedOuterJoins()- This method tests whether or not the database supports limited outer joins.
|
boolean | supportsMinimumSQLGrammar()- This method tests whether or not the minimum grammer for ODBC is supported.
|
boolean | supportsMixedCaseIdentifiers()- This method tests whether or not the database supports identifiers
with mixed case.
|
boolean | supportsMixedCaseQuotedIdentifiers()- This method tests whether or not the database supports quoted identifiers
with mixed case.
|
boolean | supportsMultipleOpenResults()- This method tests whether the database supports returning multiple
ResultSetS from a CallableStatement at once.
|
boolean | supportsMultipleResultSets()- This method tests whether multiple result sets for a single statement are
supported.
|
boolean | supportsMultipleTransactions()- This method test whether or not multiple transactions may be open
at once, as long as they are on different connections.
|
boolean | supportsNamedParameters()- This method tests whether the database supports named parameters.
|
boolean | supportsNonNullableColumns()- This method tests whether or not columns can be defined as NOT NULL.
|
boolean | supportsOpenCursorsAcrossCommit()- This method tests whether or not the database supports cursors
remaining open across commits.
|
boolean | supportsOpenCursorsAcrossRollback()- This method tests whether or not the database supports cursors
remaining open across rollbacks.
|
boolean | supportsOpenStatementsAcrossCommit()- This method tests whether or not the database supports statements
remaining open across commits.
|
boolean | supportsOpenStatementsAcrossRollback()- This method tests whether or not the database supports statements
remaining open across rollbacks.
|
boolean | supportsOrderByUnrelated()- This method tests whether or ORDER BY on a non-selected column is
allowed.
|
boolean | supportsOuterJoins()- This method tests whether or not the database supports outer joins.
|
boolean | supportsPositionedDelete()- This method tests whether or not that database supports positioned
deletes.
|
boolean | supportsPositionedUpdate()- This method tests whether or not that database supports positioned
updates.
|
boolean | supportsResultSetConcurrency(int type, int concurrency)- This method tests whether the specified result set type and result set
concurrency type are supported by the database.
|
boolean | supportsResultSetHoldability(int holdability)- This method tests if the database supports the specified holdability type.
|
boolean | supportsResultSetType(int type)- This method tests whether or not the datbase supports the specified
result type.
|
boolean | supportsSavepoints()- This method tests whether the databse supports savepoints.
|
boolean | supportsSchemasInDataManipulation()- This method tests whether a catalog name can appear in a data
manipulation statement.
|
boolean | supportsSchemasInIndexDefinitions()- This method tests whether a catalog name can appear in an index definition.
|
boolean | supportsSchemasInPrivilegeDefinitions()- This method tests whether a catalog name can appear in privilege definitions.
|
boolean | supportsSchemasInProcedureCalls()- This method tests whether a catalog name can appear in a procedure
call
|
boolean | supportsSchemasInTableDefinitions()- This method tests whether a catalog name can appear in a table definition.
|
boolean | supportsSelectForUpdate()- This method tests whether or not SELECT FOR UPDATE is supported by the
database.
|
boolean | supportsStatementPooling()
|
boolean | supportsStoredProcedures()- This method tests whether or not stored procedures are supported on
this database.
|
boolean | supportsSubqueriesInComparisons()- This method tests whether or not subqueries are allowed in comparisons.
|
boolean | supportsSubqueriesInExists()- This method tests whether or not subqueries are allowed in exists
expressions.
|
boolean | supportsSubqueriesInIns()- This method tests whether subqueries are allowed in IN statements.
|
boolean | supportsSubqueriesInQuantifieds()- This method tests whether or not subqueries are allowed in quantified
expressions.
|
boolean | supportsTableCorrelationNames()- This method tests whether or not table correlation names are
supported.
|
boolean | supportsTransactionIsolationLevel(int level)- This method tests whether or not the database supports the specified
transaction isolation level.
|
boolean | supportsTransactions()- This method tests whether or not the database supports transactions.
|
boolean | supportsUnion()- This method tests whether or not the UNION statement is supported.
|
boolean | supportsUnionAll()- This method tests whether or not the UNION ALL statement is supported.
|
boolean | updatesAreDetected(int type)- This method tests whether or not the specified result set type can detect
a visible update by calling the
rowUpdated method.
|
boolean | usesLocalFilePerTable()- This method tests whether or not the database uses a separate file for
each table.
|
boolean | usesLocalFiles()- This method tests whether or not the database uses local files to
store tables.
|