The Dialect type exposes the following members.

Properties

  NameDescription
AddColumnString
The syntax used to add a column to a table. Note this is deprecated
BindLimitParametersFirst
Does the LIMIT clause come at the start of the SELECT statement rather than at the end?
BindLimitParametersInReverseOrder
Does the LIMIT clause specify arguments in the "reverse" order limit, offset instead of offset, limit?
CascadeConstraintsString
Completely optional cascading drop clause
CloseQuote
The closing quote for a quoted identifier.
DefaultProperties
Retrieve a set of default Hibernate properties for this database.
DropConstraints
Do we need to drop constraints before dropping tables in the dialect?
ForUpdateNowaitString
Retrieves the FOR UPDATE NOWAIT syntax specific to this dialect
ForUpdateOfColumns
ForUpdateString
Retrieves the FOR UPDATE syntax specific to this dialect
Functions
Aggregate SQL functions as defined in general. This is a case-insensitive hashtable!
HasAlterTable
Does this dialect support the ALTER TABLE syntax?
HasDataTypeInIdentityColumn
Whether this dialect has an identity clause added to the data type or a completely seperate identity data type.
IdentityColumnString
The keyword used to specify an identity column, if native key generation is supported
IdentityInsertString
The keyword used to insert a generated value into an identity column (or null)
LowercaseFunction
The name of the SQL function that transforms a string to lowercase
MaxAliasLength
MultipleQueriesSeparator
How we seperate the queries when we use multiply queries.
NoColumnsInsertString
The keyword used to insert a row without specifying any column values
NullColumnString
The keyword used to specify a nullable column
OpenQuote
The opening quote for a quoted identifier.
QualifyIndexName
Do we need to qualify index names with the schema name?
SupportsIdentityColumns
Does this dialect support identity column key generation?
SupportsIfExistsAfterTableName
Does the dialect support the syntax 'drop table NAME if exists'
SupportsIfExistsBeforeTableName
Does the dialect support the syntax 'drop table if exists NAME'
SupportsLimit
Does this Dialect have some kind of LIMIT syntax?
SupportsLimitOffset
Does this Dialect support an offset?
SupportsSequences
Does this dialect support sequences?
SupportsSubSelects
Does this dialect support subselects?
SupportsUnique
Does this dialect support the UNIQUE column syntax?
SupportsVariableLimit
Can parameters be used for a statement containing a LIMIT?
TimestampResolutionInTicks
Gives the best resolution that the database can use for storing date/time values, in ticks.
UseMaxForLimit
Does the LIMIT clause take a "maximum" row number instead of a total number of returned rows?

See Also