DatabaseMetaData

Represents the meta data for a database.

Methods
boolean allProceduresAreCallable()
Checks if all procedures callable.
boolean allTablesAreSelectable()
Checks if it possible to query all tables returned by getTables.
boolean autoCommitFailureClosesAllResultSets()
Returns whether an exception while auto commit is on closes all result sets.
boolean dataDefinitionCausesTransactionCommit()
Returns whether CREATE/DROP commit an open transaction.
boolean dataDefinitionIgnoredInTransactions()
Returns whether CREATE/DROP do not affect transactions.
boolean deletesAreDetected(int type)
Returns whether deletes are detected.
boolean doesMaxRowSizeIncludeBlobs()
Returns whether the maximum row size includes blobs.
ResultSet getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern)
[Not supported]
ResultSet getBestRowIdentifier(String catalog, String schema, String tableName, int scope, boolean nullable)
Gets the list of columns that best identifier a row in a table.
String getCatalogSeparator()
Returns the catalog separator.
String getCatalogTerm()
Returns the term for "catalog".
ResultSet getCatalogs()
Gets the list of catalogs.
ResultSet getClientInfoProperties()
[Not supported] Returns the client info properties.
ResultSet getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern)
Gets the list of column privileges.
ResultSet getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern)
Gets the list of columns.
Connection getConnection()
Returns the connection that created this object.
ResultSet getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable)
Gets the list of foreign key columns that references a table, as well as the list of primary key columns that are references by a table.
int getDatabaseMajorVersion()
Gets the major version of the database.
int getDatabaseMinorVersion()
Gets the minor version of the database.
String getDatabaseProductName()
Gets the database product name.
String getDatabaseProductVersion()
Gets the product version of the database.
int getDefaultTransactionIsolation()
Returns the default transaction isolation level.
int getDriverMajorVersion()
Returns the major version of this driver.
int getDriverMinorVersion()
Returns the minor version of this driver.
String getDriverName()
Gets the name of the JDBC driver.
String getDriverVersion()
Gets the version number of the driver in the format [MajorVersion].
ResultSet getExportedKeys(String catalog, String schema, String tableName)
Gets the list of foreign key columns that reference a table.
String getExtraNameCharacters()
Returns the characters that are allowed for identifiers in addiction to A-Z, a-z, 0-9 and '_'.
String getIdentifierQuoteString()
Returns the string used to quote identifiers.
ResultSet getImportedKeys(String catalog, String schema, String tableName)
Gets the list of primary key columns that are referenced by a table.
ResultSet getIndexInfo(String catalog, String schema, String tableName, boolean unique, boolean approximate)
Gets the list of indexes for this database.
int getJDBCMajorVersion()
Gets the major version of the supported JDBC API.
int getJDBCMinorVersion()
Gets the minor version of the supported JDBC API.
int getMaxBinaryLiteralLength()
Returns the maximum length for hex values (characters).
int getMaxCatalogNameLength()
Returns the maximum length for a catalog name.
int getMaxCharLiteralLength()
Returns the maximum length for literals.
int getMaxColumnNameLength()
Returns the maximum length for column names.
int getMaxColumnsInGroupBy()
Returns the maximum number of columns in GROUP BY.
int getMaxColumnsInIndex()
Returns the maximum number of columns in CREATE INDEX.
int getMaxColumnsInOrderBy()
Returns the maximum number of columns in ORDER BY.
int getMaxColumnsInSelect()
Returns the maximum number of columns in SELECT.
int getMaxColumnsInTable()
Returns the maximum number of columns in CREATE TABLE.
int getMaxConnections()
Returns the maximum number of open connection.
int getMaxCursorNameLength()
Returns the maximum length for a cursor name.
int getMaxIndexLength()
Returns the maximum length for an index (in bytes).
int getMaxProcedureNameLength()
Returns the maximum length for a procedure name.
int getMaxRowSize()
Returns the maximum size of a row (in bytes).
int getMaxSchemaNameLength()
Returns the maximum length for a schema name.
int getMaxStatementLength()
Returns the maximum length of a statement.
int getMaxStatements()
Returns the maximum number of open statements.
int getMaxTableNameLength()
Returns the maximum length for a table name.
int getMaxTablesInSelect()
Returns the maximum number of tables in a SELECT.
int getMaxUserNameLength()
Returns the maximum length for a user name.
String getNumericFunctions()
Returns the list of numeric functions supported by this database.
ResultSet getPrimaryKeys(String catalog, String schema, String tableName)
Gets the primary key columns for a table.
ResultSet getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern)
Gets the list of procedure columns.
String getProcedureTerm()
Returns the term for "procedure".
ResultSet getProcedures(String catalog, String schemaPattern, String procedureNamePattern)
Gets the list of procedures.
int getResultSetHoldability()
Gets the result set holdability.
String getSQLKeywords()
Gets the comma-separated list of all SQL keywords that are not supported as table/column/index name, in addition to the SQL-92 keywords.
int getSQLStateType()
Gets the SQL State type.
String getSchemaTerm()
Returns the term for "schema".
ResultSet getSchemas()
Gets the list of schemas.
String getSearchStringEscape()
Returns the default escape character for LIKE.
String getStringFunctions()
Returns the list of string functions supported by this database.
ResultSet getSuperTables(String catalog, String schemaPattern, String tableNamePattern)
Get the list of super tables of a table.
ResultSet getSuperTypes(String catalog, String schemaPattern, String typeNamePattern)
[Not supported]
String getSystemFunctions()
Returns the list of system functions supported by this database.
ResultSet getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern)
Gets the list of table privileges.
ResultSet getTableTypes()
Gets the list of table types.
ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types)
Gets the list of tables in the database.
String getTimeDateFunctions()
Returns the list of date and time functions supported by this database.
ResultSet getTypeInfo()
Gets the list of data types.
ResultSet getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types)
Gets the list of user-defined data types.
String getURL()
Returns the database URL for this connection.
String getUserName()
Returns the user name as passed to DriverManager.getConnection(url, user, password).
ResultSet getVersionColumns(String catalog, String schema, String tableName)
Get the list of columns that are update when any value is updated.
boolean insertsAreDetected(int type)
Returns whether inserts are detected.
boolean isCatalogAtStart()
Returns whether the catalog is at the beginning.
boolean isReadOnly()
Returns the same as Connection.isReadOnly().
boolean locatorsUpdateCopy()
Does the database make a copy before updating.
boolean nullPlusNonNullIsNull()
Returns whether NULL+1 is NULL or not.
boolean nullsAreSortedAtEnd()
Checks is NULL values are sorted at the end (no matter if ASC or DESC is used).
boolean nullsAreSortedAtStart()
Checks is NULL values are sorted at the beginning (no matter if ASC or DESC is used).
boolean nullsAreSortedHigh()
Checks is NULL values are sorted high (bigger than any non-null values).
boolean nullsAreSortedLow()
Checks is NULL values are sorted low (smaller than any non-null values).
boolean othersDeletesAreVisible(int type)
Returns whether other deletes are visible.
boolean othersInsertsAreVisible(int type)
Returns whether other inserts are visible.
boolean othersUpdatesAreVisible(int type)
Returns whether other updates are visible.
boolean ownDeletesAreVisible(int type)
Returns whether own deletes are visible.
boolean ownInsertsAreVisible(int type)
Returns whether own inserts are visible.
boolean ownUpdatesAreVisible(int type)
Returns whether own updates are visible.
boolean storesLowerCaseIdentifiers()
Checks if for CREATE TABLE Test(ID INT), getTables returns test as the table name.
boolean storesLowerCaseQuotedIdentifiers()
Checks if for CREATE TABLE "Test"(ID INT), getTables returns test as the table name.
boolean storesMixedCaseIdentifiers()
Checks if for CREATE TABLE Test(ID INT), getTables returns Test as the table name.
boolean storesMixedCaseQuotedIdentifiers()
Checks if for CREATE TABLE "Test"(ID INT), getTables returns Test as the table name.
boolean storesUpperCaseIdentifiers()
Checks if for CREATE TABLE Test(ID INT), getTables returns TEST as the table name.
boolean storesUpperCaseQuotedIdentifiers()
Checks if for CREATE TABLE "Test"(ID INT), getTables returns TEST as the table name.
boolean supportsANSI92EntryLevelSQL()
Returns whether SQL-92 entry level grammar is supported.
boolean supportsANSI92FullSQL()
Returns whether SQL-92 full level grammar is supported.
boolean supportsANSI92IntermediateSQL()
Returns whether SQL-92 intermediate level grammar is supported.
boolean supportsAlterTableWithAddColumn()
Returns whether alter table with add column is supported.
boolean supportsAlterTableWithDropColumn()
Returns whether alter table with drop column is supported.
boolean supportsBatchUpdates()
Returns whether batch updates are supported.
boolean supportsCatalogsInDataManipulation()
Returns whether the catalog name in INSERT, UPDATE, DELETE is supported.
boolean supportsCatalogsInIndexDefinitions()
Returns whether the catalog name in CREATE INDEX is supported.
boolean supportsCatalogsInPrivilegeDefinitions()
Returns whether the catalog name in GRANT is supported.
boolean supportsCatalogsInProcedureCalls()
Returns whether the catalog name in procedure calls is supported.
boolean supportsCatalogsInTableDefinitions()
Returns whether the catalog name in CREATE TABLE is supported.
boolean supportsColumnAliasing()
Returns whether column aliasing is supported.
boolean supportsConvert()
Returns whether CONVERT is supported.
boolean supportsConvert(int fromType, int toType)
Returns whether CONVERT is supported for one datatype to another.
boolean supportsCoreSQLGrammar()
Returns whether ODBC Core SQL grammar is supported.
boolean supportsCorrelatedSubqueries()
Returns whether correlated subqueries are supported.
boolean supportsDataDefinitionAndDataManipulationTransactions()
Returns whether data manipulation and CREATE/DROP is supported in transactions.
boolean supportsDataManipulationTransactionsOnly()
Returns whether only data manipulations are supported in transactions.
boolean supportsDifferentTableCorrelationNames()
Returns whether table correlation names (table alias) are restricted to be different than table names.
boolean supportsExpressionsInOrderBy()
Returns whether expression in ORDER BY are supported.
boolean supportsExtendedSQLGrammar()
Returns whether ODBC Extended SQL grammar is supported.
boolean supportsFullOuterJoins()
Returns whether full outer joins are supported.
boolean supportsGetGeneratedKeys()
Does the database support getGeneratedKeys.
boolean supportsGroupBy()
Returns whether GROUP BY is supported.
boolean supportsGroupByBeyondSelect()
Checks whether a GROUP BY clause can use columns that are not in the SELECT clause, provided that it specifies all the columns in the SELECT clause.
boolean supportsGroupByUnrelated()
Returns whether GROUP BY is supported if the column is not in the SELECT list.
boolean supportsIntegrityEnhancementFacility()
Returns whether referential integrity is supported.
boolean supportsLikeEscapeClause()
Returns whether LIKE...
boolean supportsLimitedOuterJoins()
Returns whether limited outer joins are supported.
boolean supportsMinimumSQLGrammar()
Returns whether ODBC Minimum SQL grammar is supported.
boolean supportsMixedCaseIdentifiers()
Checks if for CREATE TABLE Test(ID INT), getTables returns Test as the table name.
boolean supportsMixedCaseQuotedIdentifiers()
Checks if a table created with CREATE TABLE "Test"(ID INT) is a different table than a table created with CREATE TABLE TEST(ID INT).
boolean supportsMultipleOpenResults()
Does the database support multiple open result sets.
boolean supportsMultipleResultSets()
Returns whether multiple result sets are supported.
boolean supportsMultipleTransactions()
Returns whether multiple transactions (on different connections) are supported.
boolean supportsNamedParameters()
Does the database support named parameters.
boolean supportsNonNullableColumns()
Returns whether columns with NOT NULL are supported.
boolean supportsOpenCursorsAcrossCommit()
Returns whether open result sets across commits are supported.
boolean supportsOpenCursorsAcrossRollback()
Returns whether open result sets across rollback are supported.
boolean supportsOpenStatementsAcrossCommit()
Returns whether open statements across commit are supported.
boolean supportsOpenStatementsAcrossRollback()
Returns whether open statements across rollback are supported.
boolean supportsOrderByUnrelated()
Returns whether ORDER BY is supported if the column is not in the SELECT list.
boolean supportsOuterJoins()
Returns whether outer joins are supported.
boolean supportsPositionedDelete()
Returns whether positioned deletes are supported.
boolean supportsPositionedUpdate()
Returns whether positioned updates are supported.
boolean supportsResultSetConcurrency(int type, int concurrency)
Returns whether a specific result set concurrency is supported.
boolean supportsResultSetHoldability(int holdability)
Does this database supports a result set holdability.
boolean supportsResultSetType(int type)
Returns whether a specific result set type is supported.
boolean supportsSavepoints()
Does the database support savepoints.
boolean supportsSchemasInDataManipulation()
Returns whether the schema name in INSERT, UPDATE, DELETE is supported.
boolean supportsSchemasInIndexDefinitions()
Returns whether the schema name in CREATE INDEX is supported.
boolean supportsSchemasInPrivilegeDefinitions()
Returns whether the schema name in GRANT is supported.
boolean supportsSchemasInProcedureCalls()
Returns whether the schema name in procedure calls is supported.
boolean supportsSchemasInTableDefinitions()
Returns whether the schema name in CREATE TABLE is supported.
boolean supportsSelectForUpdate()
Returns whether SELECT ...
boolean supportsStatementPooling()
Does the database support statement pooling.
boolean supportsStoredFunctionsUsingCallSyntax()
Returns whether the database supports calling functions using the call syntax.
boolean supportsStoredProcedures()
Returns whether stored procedures are supported.
boolean supportsSubqueriesInComparisons()
Returns whether subqueries (SELECT) in comparisons are supported.
boolean supportsSubqueriesInExists()
Returns whether SELECT in EXISTS is supported.
boolean supportsSubqueriesInIns()
Returns whether IN(SELECT...) is supported.
boolean supportsSubqueriesInQuantifieds()
Returns whether subqueries in quantified expression are supported.
boolean supportsTableCorrelationNames()
Returns whether table correlation names (table alias) are supported.
boolean supportsTransactionIsolationLevel(int level)
Returns whether a specific transaction isolation level is supported.
boolean supportsTransactions()
Returns whether transactions are supported.
boolean supportsUnion()
Returns whether UNION SELECT is supported.
boolean supportsUnionAll()
Returns whether UNION ALL SELECT is supported.
boolean updatesAreDetected(int type)
Returns whether updates are detected.
boolean usesLocalFilePerTable()
Checks if this database use one file per table.
boolean usesLocalFiles()
Checks if this database store data in local files.

boolean allProceduresAreCallable()

Checks if all procedures callable.

Returns:
true

boolean allTablesAreSelectable()

Checks if it possible to query all tables returned by getTables.

Returns:
true

boolean autoCommitFailureClosesAllResultSets()

Returns whether an exception while auto commit is on closes all result sets.

Returns:
false

boolean dataDefinitionCausesTransactionCommit()

Returns whether CREATE/DROP commit an open transaction.

Returns:
true

boolean dataDefinitionIgnoredInTransactions()

Returns whether CREATE/DROP do not affect transactions.

Returns:
false

boolean deletesAreDetected(int type)

Returns whether deletes are detected.

Returns:
false

boolean doesMaxRowSizeIncludeBlobs()

Returns whether the maximum row size includes blobs.

Returns:
false

ResultSet getAttributes(String catalog, String schemaPattern, String typeNamePattern, String attributeNamePattern) throws SQLException

[Not supported]

ResultSet getBestRowIdentifier(String catalog, String schema, String tableName, int scope, boolean nullable) throws SQLException

Gets the list of columns that best identifier a row in a table. The list is ordered by SCOPE.
  • 1 SCOPE (short) scope of result (always bestRowSession)
  • 2 COLUMN_NAME (String) column name
  • 3 DATA_TYPE (short) SQL data type, see also java.sql.Types
  • 4 TYPE_NAME (String) type name
  • 5 COLUMN_SIZE (int) precision
  • 6 BUFFER_LENGTH (int) unused
  • 7 DECIMAL_DIGITS (short) scale
  • 8 PSEUDO_COLUMN (short) (always bestRowNotPseudo)


Parameters:
catalog - null (to get all objects) or the catalog name
schema - schema name (must be specified)
tableName - table name (must be specified)
scope - ignored
nullable - ignored
Returns:
the primary key index
Throws:
SQLException - if the connection is closed

String getCatalogSeparator()

Returns the catalog separator.

Returns:
"."

String getCatalogTerm()

Returns the term for "catalog".

Returns:
"catalog"

ResultSet getCatalogs() throws SQLException

Gets the list of catalogs. The result set is sorted by TABLE_CAT.
  • 1 TABLE_CAT (String) catalog name


Returns:
the catalog list
Throws:
SQLException - if the connection is closed

ResultSet getClientInfoProperties() throws SQLException

[Not supported] Returns the client info properties.

ResultSet getColumnPrivileges(String catalog, String schema, String table, String columnNamePattern) throws SQLException

Gets the list of column privileges. The result set is sorted by COLUMN_NAME and PRIVILEGE
  • 1 TABLE_CAT (String) table catalog
  • 2 TABLE_SCHEM (String) table schema
  • 3 TABLE_NAME (String) table name
  • 4 COLUMN_NAME (String) column name
  • 5 GRANTOR (String) grantor of access
  • 6 GRANTEE (String) grantee of access
  • 7 PRIVILEGE (String) SELECT, INSERT, UPDATE, DELETE or REFERENCES (only one per row)
  • 8 IS_GRANTABLE (String) YES means the grantee can grant access to others


Parameters:
catalog - null (to get all objects) or the catalog name
schema - null (to get all objects) or a schema name (uppercase for unquoted names)
table - a table name (uppercase for unquoted names)
columnNamePattern - null (to get all objects) or a column name (uppercase for unquoted names)
Returns:
the list of privileges
Throws:
SQLException - if the connection is closed

ResultSet getColumns(String catalog, String schemaPattern, String tableNamePattern, String columnNamePattern) throws SQLException

Gets the list of columns. The result set is sorted by TABLE_SCHEM, TABLE_NAME, and ORDINAL_POSITION.
  • 1 TABLE_CAT (String) table catalog
  • 2 TABLE_SCHEM (String) table schema
  • 3 TABLE_NAME (String) table name
  • 4 COLUMN_NAME (String) column name
  • 5 DATA_TYPE (short) data type (see java.sql.Types)
  • 6 TYPE_NAME (String) data type name ("INTEGER", "VARCHAR",...)
  • 7 COLUMN_SIZE (int) precision
  • 8 BUFFER_LENGTH (int) unused
  • 9 DECIMAL_DIGITS (int) scale (0 for INTEGER and VARCHAR)
  • 10 NUM_PREC_RADIX (int) radix (always 10)
  • 11 NULLABLE (int) nullable or not. columnNoNulls or columnNullable
  • 12 REMARKS (String) comment (always empty)
  • 13 COLUMN_DEF (String) default value
  • 14 SQL_DATA_TYPE (int) unused
  • 15 SQL_DATETIME_SUB (int) unused
  • 16 CHAR_OCTET_LENGTH (int) unused
  • 17 ORDINAL_POSITION (int) the column index (1,2,...)
  • 18 IS_NULLABLE (String) "NO" or "YES"


Parameters:
catalog - null (to get all objects) or the catalog name
schemaPattern - null (to get all objects) or a schema name (uppercase for unquoted names)
tableNamePattern - null (to get all objects) or a table name (uppercase for unquoted names)
columnNamePattern - null (to get all objects) or a column name (uppercase for unquoted names)
Returns:
the list of columns
Throws:
SQLException - if the connection is closed

Connection getConnection()

Returns the connection that created this object.

Returns:
the connection

ResultSet getCrossReference(String primaryCatalog, String primarySchema, String primaryTable, String foreignCatalog, String foreignSchema, String foreignTable) throws SQLException

Gets the list of foreign key columns that references a table, as well as the list of primary key columns that are references by a table. The result set is sorted by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, FK_NAME, KEY_SEQ.
  • 1 PKTABLE_CAT (String) primary catalog
  • 2 PKTABLE_SCHEM (String) primary schema
  • 3 PKTABLE_NAME (String) primary table
  • 4 PKCOLUMN_NAME (String) primary column
  • 5 FKTABLE_CAT (String) foreign catalog
  • 6 FKTABLE_SCHEM (String) foreign schema
  • 7 FKTABLE_NAME (String) foreign table
  • 8 FKCOLUMN_NAME (String) foreign column
  • 9 KEY_SEQ (short) sequence number (1,2,...)
  • 10 UPDATE_RULE (short) action on update (see DatabaseMetaData.importedKey...)
  • 11 DELETE_RULE (short) action on delete (see DatabaseMetaData.importedKey...)
  • 12 FK_NAME (String) foreign key name
  • 13 PK_NAME (String) primary key name
  • 14 DEFERRABILITY (short) deferrable or not (always importedKeyNotDeferrable)


Parameters:
primaryCatalog - ignored
primarySchema - the schema name of the primary table (must be specified)
primaryTable - the name of the primary table (must be specified)
foreignCatalog - ignored
foreignSchema - the schema name of the foreign table (must be specified)
foreignTable - the name of the foreign table (must be specified)
Returns:
the result set
Throws:
SQLException - if the connection is closed

int getDatabaseMajorVersion()

Gets the major version of the database.

Returns:
the major version

int getDatabaseMinorVersion()

Gets the minor version of the database.

Returns:
the minor version

String getDatabaseProductName()

Gets the database product name.

Returns:
the product name

String getDatabaseProductVersion()

Gets the product version of the database.

Returns:
the product version

int getDefaultTransactionIsolation()

Returns the default transaction isolation level.

Returns:
Connection.TRANSACTION_READ_COMMITTED

int getDriverMajorVersion()

Returns the major version of this driver.

Returns:
the major version number

int getDriverMinorVersion()

Returns the minor version of this driver.

Returns:
the minor version number

String getDriverName()

Gets the name of the JDBC driver.

Returns:
the driver name

String getDriverVersion()

Gets the version number of the driver in the format [MajorVersion].[MinorVersion].

Returns:
the version number

ResultSet getExportedKeys(String catalog, String schema, String tableName) throws SQLException

Gets the list of foreign key columns that reference a table. The result set is sorted by FKTABLE_CAT, FKTABLE_SCHEM, FKTABLE_NAME, FK_NAME, KEY_SEQ.
  • 1 PKTABLE_CAT (String) primary catalog
  • 2 PKTABLE_SCHEM (String) primary schema
  • 3 PKTABLE_NAME (String) primary table
  • 4 PKCOLUMN_NAME (String) primary column
  • 5 FKTABLE_CAT (String) foreign catalog
  • 6 FKTABLE_SCHEM (String) foreign schema
  • 7 FKTABLE_NAME (String) foreign table
  • 8 FKCOLUMN_NAME (String) foreign column
  • 9 KEY_SEQ (short) sequence number (1,2,...)
  • 10 UPDATE_RULE (short) action on update (see DatabaseMetaData.importedKey...)
  • 11 DELETE_RULE (short) action on delete (see DatabaseMetaData.importedKey...)
  • 12 FK_NAME (String) foreign key name
  • 13 PK_NAME (String) primary key name
  • 14 DEFERRABILITY (short) deferrable or not (always importedKeyNotDeferrable)


Parameters:
catalog - null (to get all objects) or the catalog name
schema - the schema name of the primary table
tableName - the name of the primary table
Returns:
the result set
Throws:
SQLException - if the connection is closed

String getExtraNameCharacters()

Returns the characters that are allowed for identifiers in addiction to A-Z, a-z, 0-9 and '_'.

Returns:
an empty String ("")

String getIdentifierQuoteString()

Returns the string used to quote identifiers.

Returns:
a double quote

ResultSet getImportedKeys(String catalog, String schema, String tableName) throws SQLException

Gets the list of primary key columns that are referenced by a table. The result set is sorted by PKTABLE_CAT, PKTABLE_SCHEM, PKTABLE_NAME, FK_NAME, KEY_SEQ.
  • 1 PKTABLE_CAT (String) primary catalog
  • 2 PKTABLE_SCHEM (String) primary schema
  • 3 PKTABLE_NAME (String) primary table
  • 4 PKCOLUMN_NAME (String) primary column
  • 5 FKTABLE_CAT (String) foreign catalog
  • 6 FKTABLE_SCHEM (String) foreign schema
  • 7 FKTABLE_NAME (String) foreign table
  • 8 FKCOLUMN_NAME (String) foreign column
  • 9 KEY_SEQ (short) sequence number (1, 2, ...)
  • 10 UPDATE_RULE (short) action on update (see DatabaseMetaData.importedKey...)
  • 11 DELETE_RULE (short) action on delete (see DatabaseMetaData.importedKey...)
  • 12 FK_NAME (String) foreign key name
  • 13 PK_NAME (String) primary key name
  • 14 DEFERRABILITY (short) deferrable or not (always importedKeyNotDeferrable)


Parameters:
catalog - null (to get all objects) or the catalog name
schema - the schema name of the foreign table
tableName - the name of the foreign table
Returns:
the result set
Throws:
SQLException - if the connection is closed

ResultSet getIndexInfo(String catalog, String schema, String tableName, boolean unique, boolean approximate) throws SQLException

Gets the list of indexes for this database. The primary key index (if there is one) is also listed, with the name PRIMARY_KEY. The result set is sorted by NON_UNIQUE ('false' first), TYPE, TABLE_SCHEM, INDEX_NAME, and ORDINAL_POSITION.
  • 1 TABLE_CAT (String) table catalog
  • 2 TABLE_SCHEM (String) table schema
  • 3 TABLE_NAME (String) table name
  • 4 NON_UNIQUE (boolean) 'false' for unique, 'true' for non-unique
  • 5 INDEX_QUALIFIER (String) index catalog
  • 6 INDEX_NAME (String) index name
  • 7 TYPE (short) the index type (always tableIndexOther)
  • 8 ORDINAL_POSITION (short) column index (1, 2, ...)
  • 9 COLUMN_NAME (String) column name
  • 10 ASC_OR_DESC (String) ascending or descending (always 'A')
  • 11 CARDINALITY (int) numbers of unique values
  • 12 PAGES (int) number of pages use (always 0)
  • 13 FILTER_CONDITION (String) filter condition (always empty)
  • 14 SORT_TYPE (int) the sort type bit map: 1=DESCENDING, 2=NULLS_FIRST, 4=NULLS_LAST


Parameters:
catalog - null (to get all objects) or the catalog name
schema - schema name (must be specified)
tableName - table name (must be specified)
unique - only unique indexes
approximate - is ignored
Returns:
the list of indexes and columns
Throws:
SQLException - if the connection is closed

int getJDBCMajorVersion()

Gets the major version of the supported JDBC API.

Returns:
the major version

int getJDBCMinorVersion()

Gets the minor version of the supported JDBC API.

Returns:
the minor version

int getMaxBinaryLiteralLength()

Returns the maximum length for hex values (characters).

Returns:
0 for limit is unknown

int getMaxCatalogNameLength()

Returns the maximum length for a catalog name.

Returns:
0 for limit is unknown

int getMaxCharLiteralLength()

Returns the maximum length for literals.

Returns:
0 for limit is unknown

int getMaxColumnNameLength()

Returns the maximum length for column names.

Returns:
0 for limit is unknown

int getMaxColumnsInGroupBy()

Returns the maximum number of columns in GROUP BY.

Returns:
0 for limit is unknown

int getMaxColumnsInIndex()

Returns the maximum number of columns in CREATE INDEX.

Returns:
0 for limit is unknown

int getMaxColumnsInOrderBy()

Returns the maximum number of columns in ORDER BY.

Returns:
0 for limit is unknown

int getMaxColumnsInSelect()

Returns the maximum number of columns in SELECT.

Returns:
0 for limit is unknown

int getMaxColumnsInTable()

Returns the maximum number of columns in CREATE TABLE.

Returns:
0 for limit is unknown

int getMaxConnections()

Returns the maximum number of open connection.

Returns:
0 for limit is unknown

int getMaxCursorNameLength()

Returns the maximum length for a cursor name.

Returns:
0 for limit is unknown

int getMaxIndexLength()

Returns the maximum length for an index (in bytes).

Returns:
0 for limit is unknown

int getMaxProcedureNameLength()

Returns the maximum length for a procedure name.

Returns:
0 for limit is unknown

int getMaxRowSize()

Returns the maximum size of a row (in bytes).

Returns:
0 for limit is unknown

int getMaxSchemaNameLength()

Returns the maximum length for a schema name.

Returns:
0 for limit is unknown

int getMaxStatementLength()

Returns the maximum length of a statement.

Returns:
0 for limit is unknown

int getMaxStatements()

Returns the maximum number of open statements.

Returns:
0 for limit is unknown

int getMaxTableNameLength()

Returns the maximum length for a table name.

Returns:
0 for limit is unknown

int getMaxTablesInSelect()

Returns the maximum number of tables in a SELECT.

Returns:
0 for limit is unknown

int getMaxUserNameLength()

Returns the maximum length for a user name.

Returns:
0 for limit is unknown

String getNumericFunctions() throws SQLException

Returns the list of numeric functions supported by this database.

Returns:
the list

ResultSet getPrimaryKeys(String catalog, String schema, String tableName) throws SQLException

Gets the primary key columns for a table. The result set is sorted by TABLE_SCHEM, and COLUMN_NAME (and not by KEY_SEQ).
  • 1 TABLE_CAT (String) table catalog
  • 2 TABLE_SCHEM (String) table schema
  • 3 TABLE_NAME (String) table name
  • 4 COLUMN_NAME (String) column name
  • 5 KEY_SEQ (short) the column index of this column (1,2,...)
  • 6 PK_NAME (String) always 'PRIMARY_KEY'


Parameters:
catalog - null (to get all objects) or the catalog name
schema - schema name (must be specified)
tableName - table name (must be specified)
Returns:
the list of primary key columns
Throws:
SQLException - if the connection is closed

ResultSet getProcedureColumns(String catalog, String schemaPattern, String procedureNamePattern, String columnNamePattern) throws SQLException

Gets the list of procedure columns. The result set is sorted by PROCEDURE_SCHEM, PROCEDURE_NAME, NUM_INPUT_PARAMS, and POS. There are potentially multiple procedures with the same name, each with a different number of input parameters.
  • 1 PROCEDURE_CAT (String) catalog
  • 2 PROCEDURE_SCHEM (String) schema
  • 3 PROCEDURE_NAME (String) name
  • 4 COLUMN_NAME (String) column name
  • 5 COLUMN_TYPE (short) column type
  • 6 DATA_TYPE (short) sql type
  • 7 TYPE_NAME (String) type name
  • 8 PRECISION (int) precision
  • 9 LENGTH (int) length
  • 10 SCALE (short) scale
  • 11 RADIX (int) always 10
  • 12 NULLABLE (short) nullable
  • 13 REMARKS (String) description
  • 14 NUM_INPUT_PARAMS (int) the parameter count
  • 15 POS (int) the parameter index


Throws:
SQLException - if the connection is closed

String getProcedureTerm()

Returns the term for "procedure".

Returns:
"procedure"

ResultSet getProcedures(String catalog, String schemaPattern, String procedureNamePattern) throws SQLException

Gets the list of procedures. The result set is sorted by PROCEDURE_SCHEM, PROCEDURE_NAME, and NUM_INPUT_PARAMS. There are potentially multiple procedures with the same name, each with a different number of input parameters.
  • 1 PROCEDURE_CAT (String) catalog
  • 2 PROCEDURE_SCHEM (String) schema
  • 3 PROCEDURE_NAME (String) name
  • 4 NUM_INPUT_PARAMS (int) the number of arguments
  • 5 NUM_OUTPUT_PARAMS (int) for future use, always 0
  • 6 NUM_RESULT_SETS (int) for future use, always 0
  • 7 REMARKS (String) description
  • 8 PROCEDURE_TYPE (short) if this procedure returns a result (procedureNoResult or procedureReturnsResult)


Returns:
the procedures.
Throws:
SQLException - if the connection is closed

int getResultSetHoldability()

Gets the result set holdability.

Returns:
ResultSet.CLOSE_CURSORS_AT_COMMIT

String getSQLKeywords()

Gets the comma-separated list of all SQL keywords that are not supported as table/column/index name, in addition to the SQL-92 keywords.

Returns:
a list with the keywords

int getSQLStateType()

Gets the SQL State type.

Returns:
DatabaseMetaData.sqlStateSQL99

String getSchemaTerm()

Returns the term for "schema".

Returns:
"schema"

ResultSet getSchemas() throws SQLException

Gets the list of schemas. The result set is sorted by TABLE_SCHEM.
  • 1 TABLE_SCHEM (String) schema name
  • 2 TABLE_CATALOG (String) catalog name
  • 3 IS_DEFAULT (boolean) if this is the default schema


Returns:
the schema list
Throws:
SQLException - if the connection is closed

String getSearchStringEscape()

Returns the default escape character for LIKE.

Returns:
the character '\'

String getStringFunctions() throws SQLException

Returns the list of string functions supported by this database.

Returns:
the list

ResultSet getSuperTables(String catalog, String schemaPattern, String tableNamePattern) throws SQLException

Get the list of super tables of a table. This method currently returns an empty result set.
  • 1 TABLE_CAT (String) table catalog
  • 2 TABLE_SCHEM (String) table schema
  • 3 TABLE_NAME (String) table name
  • 4 SUPERTABLE_NAME (String) the name of the super table


Returns:
an empty result set

ResultSet getSuperTypes(String catalog, String schemaPattern, String typeNamePattern) throws SQLException

[Not supported]

String getSystemFunctions() throws SQLException

Returns the list of system functions supported by this database.

Returns:
the list

ResultSet getTablePrivileges(String catalog, String schemaPattern, String tableNamePattern) throws SQLException

Gets the list of table privileges. The result set is sorted by TABLE_SCHEM, TABLE_NAME, and PRIVILEGE.
  • 1 TABLE_CAT (String) table catalog
  • 2 TABLE_SCHEM (String) table schema
  • 3 TABLE_NAME (String) table name
  • 4 GRANTOR (String) grantor of access
  • 5 GRANTEE (String) grantee of access
  • 6 PRIVILEGE (String) SELECT, INSERT, UPDATE, DELETE or REFERENCES (only one per row)
  • 7 IS_GRANTABLE (String) YES means the grantee can grant access to others


Parameters:
catalog - null (to get all objects) or the catalog name
schemaPattern - null (to get all objects) or a schema name (uppercase for unquoted names)
tableNamePattern - null (to get all objects) or a table name (uppercase for unquoted names)
Returns:
the list of privileges
Throws:
SQLException - if the connection is closed

ResultSet getTableTypes() throws SQLException

Gets the list of table types. This call returns a result set with three records: "SYSTEM TABLE", "TABLE", "and "VIEW". The result set is sorted by TABLE_TYPE.
  • 1 TABLE_TYPE (String) table type


Returns:
the table types
Throws:
SQLException - if the connection is closed

ResultSet getTables(String catalog, String schemaPattern, String tableNamePattern, String[] types) throws SQLException

Gets the list of tables in the database. The result set is sorted by TABLE_TYPE, TABLE_SCHEM, and TABLE_NAME.
  • 1 TABLE_CAT (String) table catalog
  • 2 TABLE_SCHEM (String) table schema
  • 3 TABLE_NAME (String) table name
  • 4 TABLE_TYPE (String) table type
  • 5 REMARKS (String) comment
  • 6 SQL (String) the create table statement or NULL for systems tables


Parameters:
catalog - null (to get all objects) or the catalog name
schemaPattern - null (to get all objects) or a schema name (uppercase for unquoted names)
tableNamePattern - null (to get all objects) or a table name (uppercase for unquoted names)
types - null or a list of table types
Returns:
the list of columns
Throws:
SQLException - if the connection is closed

String getTimeDateFunctions() throws SQLException

Returns the list of date and time functions supported by this database.

Returns:
the list

ResultSet getTypeInfo() throws SQLException

Gets the list of data types. The result set is sorted by DATA_TYPE and afterwards by how closely the data type maps to the corresponding JDBC SQL type (best match first).
  • 1 TYPE_NAME (String) type name
  • 2 DATA_TYPE (short) SQL data type - see also java.sql.Types
  • 3 PRECISION (int) maximum precision
  • 4 LITERAL_PREFIX (String) prefix used to quote a literal
  • 5 LITERAL_SUFFIX (String) suffix used to quote a literal
  • 6 CREATE_PARAMS (String) parameters used (may be null)
  • 7 NULLABLE (short) typeNoNulls (NULL not allowed) or typeNullable
  • 8 CASE_SENSITIVE (boolean) case sensitive
  • 9 SEARCHABLE (short) typeSearchable
  • 10 UNSIGNED_ATTRIBUTE (boolean) unsigned
  • 11 FIXED_PREC_SCALE (boolean) fixed precision
  • 12 AUTO_INCREMENT (boolean) auto increment
  • 13 LOCAL_TYPE_NAME (String) localized version of the data type
  • 14 MINIMUM_SCALE (short) minimum scale
  • 15 MAXIMUM_SCALE (short) maximum scale
  • 16 SQL_DATA_TYPE (int) unused
  • 17 SQL_DATETIME_SUB (int) unused
  • 18 NUM_PREC_RADIX (int) 2 for binary, 10 for decimal


Returns:
the list of data types
Throws:
SQLException - if the connection is closed

ResultSet getUDTs(String catalog, String schemaPattern, String typeNamePattern, int[] types) throws SQLException

Gets the list of user-defined data types. This call returns an empty result set.
  • 1 TYPE_CAT (String) catalog
  • 2 TYPE_SCHEM (String) schema
  • 3 TYPE_NAME (String) type name
  • 4 CLASS_NAME (String) Java class
  • 5 DATA_TYPE (short) SQL Type - see also java.sql.Types
  • 6 REMARKS (String) description
  • 7 BASE_TYPE (short) base type - see also java.sql.Types


Parameters:
catalog - ignored
schemaPattern - ignored
typeNamePattern - ignored
types - ignored
Returns:
an empty result set
Throws:
SQLException - if the connection is closed

String getURL() throws SQLException

Returns the database URL for this connection.

Returns:
the url

String getUserName() throws SQLException

Returns the user name as passed to DriverManager.getConnection(url, user, password).

Returns:
the user name

ResultSet getVersionColumns(String catalog, String schema, String tableName) throws SQLException

Get the list of columns that are update when any value is updated.
  • 1 SCOPE (int) not used
  • 2 COLUMN_NAME (String) column name
  • 3 DATA_TYPE (int) SQL data type - see also java.sql.Types
  • 4 TYPE_NAME (String) data type name
  • 5 COLUMN_SIZE (int) precision
  • 6 BUFFER_LENGTH (int) length (bytes)
  • 7 DECIMAL_DIGITS (int) scale
  • 8 PSEUDO_COLUMN (int) is this column a pseudo column


Parameters:
catalog - null (to get all objects) or the catalog name
schema - schema name (must be specified)
tableName - table name (must be specified)
Returns:
an empty result set
Throws:
SQLException - if the connection is closed

boolean insertsAreDetected(int type)

Returns whether inserts are detected.

Returns:
false

boolean isCatalogAtStart()

Returns whether the catalog is at the beginning.

Returns:
true

boolean isReadOnly() throws SQLException

Returns the same as Connection.isReadOnly().

Returns:
if read only optimization is switched on

boolean locatorsUpdateCopy()

Does the database make a copy before updating.

Returns:
false

boolean nullPlusNonNullIsNull()

Returns whether NULL+1 is NULL or not.

Returns:
true

boolean nullsAreSortedAtEnd()

Checks is NULL values are sorted at the end (no matter if ASC or DESC is used).

Returns:
false

boolean nullsAreSortedAtStart()

Checks is NULL values are sorted at the beginning (no matter if ASC or DESC is used).

Returns:
false

boolean nullsAreSortedHigh()

Checks is NULL values are sorted high (bigger than any non-null values).

Returns:
false by default; true if the system property h2.sortNullsHigh is set to true

boolean nullsAreSortedLow()

Checks is NULL values are sorted low (smaller than any non-null values).

Returns:
true by default; false if the system property h2.sortNullsHigh is set to true

boolean othersDeletesAreVisible(int type)

Returns whether other deletes are visible.

Returns:
false

boolean othersInsertsAreVisible(int type)

Returns whether other inserts are visible.

Returns:
false

boolean othersUpdatesAreVisible(int type)

Returns whether other updates are visible.

Returns:
false

boolean ownDeletesAreVisible(int type)

Returns whether own deletes are visible.

Returns:
false

boolean ownInsertsAreVisible(int type)

Returns whether own inserts are visible.

Returns:
false

boolean ownUpdatesAreVisible(int type)

Returns whether own updates are visible.

Returns:
true

boolean storesLowerCaseIdentifiers()

Checks if for CREATE TABLE Test(ID INT), getTables returns test as the table name.

Returns:
false

boolean storesLowerCaseQuotedIdentifiers()

Checks if for CREATE TABLE "Test"(ID INT), getTables returns test as the table name.

Returns:
false

boolean storesMixedCaseIdentifiers()

Checks if for CREATE TABLE Test(ID INT), getTables returns Test as the table name.

Returns:
false

boolean storesMixedCaseQuotedIdentifiers()

Checks if for CREATE TABLE "Test"(ID INT), getTables returns Test as the table name.

Returns:
true

boolean storesUpperCaseIdentifiers()

Checks if for CREATE TABLE Test(ID INT), getTables returns TEST as the table name.

Returns:
true

boolean storesUpperCaseQuotedIdentifiers()

Checks if for CREATE TABLE "Test"(ID INT), getTables returns TEST as the table name.

Returns:
false

boolean supportsANSI92EntryLevelSQL()

Returns whether SQL-92 entry level grammar is supported.

Returns:
true

boolean supportsANSI92FullSQL()

Returns whether SQL-92 full level grammar is supported.

Returns:
false

boolean supportsANSI92IntermediateSQL()

Returns whether SQL-92 intermediate level grammar is supported.

Returns:
false

boolean supportsAlterTableWithAddColumn()

Returns whether alter table with add column is supported.

Returns:
true

boolean supportsAlterTableWithDropColumn()

Returns whether alter table with drop column is supported.

Returns:
true

boolean supportsBatchUpdates()

Returns whether batch updates are supported.

Returns:
true

boolean supportsCatalogsInDataManipulation()

Returns whether the catalog name in INSERT, UPDATE, DELETE is supported.

Returns:
true

boolean supportsCatalogsInIndexDefinitions()

Returns whether the catalog name in CREATE INDEX is supported.

Returns:
true

boolean supportsCatalogsInPrivilegeDefinitions()

Returns whether the catalog name in GRANT is supported.

Returns:
true

boolean supportsCatalogsInProcedureCalls()

Returns whether the catalog name in procedure calls is supported.

Returns:
false

boolean supportsCatalogsInTableDefinitions()

Returns whether the catalog name in CREATE TABLE is supported.

Returns:
true

boolean supportsColumnAliasing()

Returns whether column aliasing is supported.

Returns:
true

boolean supportsConvert()

Returns whether CONVERT is supported.

Returns:
true

boolean supportsConvert(int fromType, int toType)

Returns whether CONVERT is supported for one datatype to another.

Returns:
true

boolean supportsCoreSQLGrammar()

Returns whether ODBC Core SQL grammar is supported.

Returns:
true

boolean supportsCorrelatedSubqueries()

Returns whether correlated subqueries are supported.

Returns:
true

boolean supportsDataDefinitionAndDataManipulationTransactions()

Returns whether data manipulation and CREATE/DROP is supported in transactions.

Returns:
false

boolean supportsDataManipulationTransactionsOnly()

Returns whether only data manipulations are supported in transactions.

Returns:
true

boolean supportsDifferentTableCorrelationNames()

Returns whether table correlation names (table alias) are restricted to be different than table names.

Returns:
false

boolean supportsExpressionsInOrderBy()

Returns whether expression in ORDER BY are supported.

Returns:
true

boolean supportsExtendedSQLGrammar()

Returns whether ODBC Extended SQL grammar is supported.

Returns:
false

boolean supportsFullOuterJoins()

Returns whether full outer joins are supported.

Returns:
false

boolean supportsGetGeneratedKeys()

Does the database support getGeneratedKeys.

Returns:
true

boolean supportsGroupBy()

Returns whether GROUP BY is supported.

Returns:
true

boolean supportsGroupByBeyondSelect()

Checks whether a GROUP BY clause can use columns that are not in the SELECT clause, provided that it specifies all the columns in the SELECT clause.

Returns:
true

boolean supportsGroupByUnrelated()

Returns whether GROUP BY is supported if the column is not in the SELECT list.

Returns:
true

boolean supportsIntegrityEnhancementFacility()

Returns whether referential integrity is supported.

Returns:
true

boolean supportsLikeEscapeClause()

Returns whether LIKE... ESCAPE is supported.

Returns:
true

boolean supportsLimitedOuterJoins()

Returns whether limited outer joins are supported.

Returns:
true

boolean supportsMinimumSQLGrammar()

Returns whether ODBC Minimum SQL grammar is supported.

Returns:
true

boolean supportsMixedCaseIdentifiers()

Checks if for CREATE TABLE Test(ID INT), getTables returns Test as the table name.

Returns:
false

boolean supportsMixedCaseQuotedIdentifiers()

Checks if a table created with CREATE TABLE "Test"(ID INT) is a different table than a table created with CREATE TABLE TEST(ID INT).

Returns:
true

boolean supportsMultipleOpenResults()

Does the database support multiple open result sets.

Returns:
true

boolean supportsMultipleResultSets()

Returns whether multiple result sets are supported.

Returns:
false

boolean supportsMultipleTransactions()

Returns whether multiple transactions (on different connections) are supported.

Returns:
true

boolean supportsNamedParameters()

Does the database support named parameters.

Returns:
false

boolean supportsNonNullableColumns()

Returns whether columns with NOT NULL are supported.

Returns:
true

boolean supportsOpenCursorsAcrossCommit()

Returns whether open result sets across commits are supported.

Returns:
false

boolean supportsOpenCursorsAcrossRollback()

Returns whether open result sets across rollback are supported.

Returns:
false

boolean supportsOpenStatementsAcrossCommit()

Returns whether open statements across commit are supported.

Returns:
true

boolean supportsOpenStatementsAcrossRollback()

Returns whether open statements across rollback are supported.

Returns:
true

boolean supportsOrderByUnrelated()

Returns whether ORDER BY is supported if the column is not in the SELECT list.

Returns:
true

boolean supportsOuterJoins()

Returns whether outer joins are supported.

Returns:
true

boolean supportsPositionedDelete()

Returns whether positioned deletes are supported.

Returns:
true

boolean supportsPositionedUpdate()

Returns whether positioned updates are supported.

Returns:
true

boolean supportsResultSetConcurrency(int type, int concurrency)

Returns whether a specific result set concurrency is supported. ResultSet.TYPE_SCROLL_SENSITIVE is not supported.

Returns:
true if the type is not ResultSet.TYPE_SCROLL_SENSITIVE

boolean supportsResultSetHoldability(int holdability)

Does this database supports a result set holdability.

Parameters:
holdability - ResultSet.HOLD_CURSORS_OVER_COMMIT or CLOSE_CURSORS_AT_COMMIT
Returns:
true if the holdability is ResultSet.CLOSE_CURSORS_AT_COMMIT

boolean supportsResultSetType(int type)

Returns whether a specific result set type is supported. ResultSet.TYPE_SCROLL_SENSITIVE is not supported.

Returns:
true for all types except ResultSet.TYPE_FORWARD_ONLY

boolean supportsSavepoints()

Does the database support savepoints.

Returns:
true

boolean supportsSchemasInDataManipulation()

Returns whether the schema name in INSERT, UPDATE, DELETE is supported.

Returns:
true

boolean supportsSchemasInIndexDefinitions()

Returns whether the schema name in CREATE INDEX is supported.

Returns:
true

boolean supportsSchemasInPrivilegeDefinitions()

Returns whether the schema name in GRANT is supported.

Returns:
true

boolean supportsSchemasInProcedureCalls()

Returns whether the schema name in procedure calls is supported.

Returns:
true

boolean supportsSchemasInTableDefinitions()

Returns whether the schema name in CREATE TABLE is supported.

Returns:
true

boolean supportsSelectForUpdate()

Returns whether SELECT ... FOR UPDATE is supported.

Returns:
true

boolean supportsStatementPooling()

Does the database support statement pooling.

Returns:
false

boolean supportsStoredFunctionsUsingCallSyntax()

Returns whether the database supports calling functions using the call syntax.

Returns:
true

boolean supportsStoredProcedures()

Returns whether stored procedures are supported.

Returns:
false

boolean supportsSubqueriesInComparisons()

Returns whether subqueries (SELECT) in comparisons are supported.

Returns:
true

boolean supportsSubqueriesInExists()

Returns whether SELECT in EXISTS is supported.

Returns:
true

boolean supportsSubqueriesInIns()

Returns whether IN(SELECT...) is supported.

Returns:
true

boolean supportsSubqueriesInQuantifieds()

Returns whether subqueries in quantified expression are supported.

Returns:
true

boolean supportsTableCorrelationNames()

Returns whether table correlation names (table alias) are supported.

Returns:
true

boolean supportsTransactionIsolationLevel(int level)

Returns whether a specific transaction isolation level is supported.

Returns:
true

boolean supportsTransactions()

Returns whether transactions are supported.

Returns:
true

boolean supportsUnion()

Returns whether UNION SELECT is supported.

Returns:
true

boolean supportsUnionAll()

Returns whether UNION ALL SELECT is supported.

Returns:
true

boolean updatesAreDetected(int type)

Returns whether updates are detected.

Returns:
false

boolean usesLocalFilePerTable()

Checks if this database use one file per table.

Returns:
false

boolean usesLocalFiles()

Checks if this database store data in local files.

Returns:
true