DatabaseDialect

Data type provider of this dialect.

Returns the default reference option for the dialect.

Function provider of this dialect.

The current H2 database compatibility mode or null if the current database is not H2.

Returns a mapping of dialect-specific characters to be escaped when used alongside the LIKE operator.

Name of this dialect.

Returns true if the dialect requires the use of quotes when using symbols in object names, false otherwise.

Returns true if the dialect requires the use of a sequence to create an auto-increment column, false otherwise.

Returns true if autoCommit should be enabled to create/drop a database.

Returnstrue if the dialect supports schema creation.

Returns true if the dialect supports the creation of sequences, false otherwise.

Returns true if the dialect provides a special dummy DUAL table, accessible by all users.

Returns true if the dialect supports the IF EXISTS/IF NOT EXISTS option when creating, altering or dropping objects, false otherwise.

Returns true if the dialect supports returning multiple generated keys as a result of an insert operation, false otherwise.

Returns true if the dialect supports only returning generated keys that are identity columns.

Returns true if the dialect supports using the ON UPDATE clause with a foreign key constraint.

Returns true if the dialect provides options to configure how nulls are sorted compared to non-null values.

Returns true if the dialect supports the RESTRICT action as part of a foreign key constraint clause.

Returns true if the dialect supports returning generated keys obtained from a sequence.

Returns true if the dialect supports the SET DEFAULT action as part of a foreign key constraint clause.

Returns true if the dialect supports subqueries within a UNION/EXCEPT/INTERSECT statement.

Returns true if the dialect supports an upsert operation returning an affected-row value of 0, 1, or 2.

Returns true if the dialect supports window function definitions with GROUPS mode in frame clause

Returns the SQL statement that adds a primary key specified pkName to an existing table.

Returns a list with the names of all the defined tables.

Returns the catalog name of the connection of the specified transaction.

Returns a map with the foreign key constraints of all the defined columns sets in each of the specified tables.

Returns the SQL statement that creates a database with the specified name.

Returns the SQL statement that creates the specified index.

Returns the SQL statement that creates the specified schema.

Returns the SQL statement that drops the database with the specified name.

Returns the SQL statement that drops the specified indexName from the specified tableName.

Returns the SQL statement that drops the specified schema, as well as all its objects if cascade is true.

Returns a map with all the defined indices in each of the specified tables.

Returns a map with the primary key metadata in each of the specified tables.

Returns the name of the current database.

Returns true if the specified e is allowed as a default column value in the dialect, false otherwise.

Returns the SQL query that retrieves a set of existing databases.

Returns the SQL statement that modifies the specified column.

Clears any cached values.

Clears any cached values including schema names.

Returns the corresponding ReferenceOption for the specified refOption from JDBC.

Checks if the specified schema exists.

Returns whether the specified sequence exists.

Returns a list of the names of all sequences in the database.

Returns the SQL statement that sets the current schema to the specified schema.

Returns true if the dialect supports SELECT FOR UPDATE statements, false otherwise.

Returns a map with the column metadata of all the defined columns in each of the specified tables.

Checks if the specified table exists in the database.