The syntax used to add a foreign key constraint to a table.
Get the name of the database type appropriate for casting operations (via the CAST() SQL function) for the given Types typecode.
Get the string to append to SELECT statements to acquire WRITE locks for this dialect.
Is this dialect known to support what ANSI-SQL terms "row value constructor" syntax; sometimes called tuple syntax.
Does this dialect support referencing the table being mutated in a subquery.
constraintName - The FK constraint name.
primaryKey - The explicit columns in the referencedTable referenced by this FK.
Basically, does it support syntax like "... where (FIRST_NAME, LAST_NAME) = ('Steve', 'Ebersole') ...".
True if this SQL dialect is known to support "row value constructor" syntax; false otherwise.
Get the string to append to SELECT statements to acquire WRITE locks for this dialect. Location of the of the returned string is treated the same as getForUpdateString.
timeout - in milliseconds, -1 for indefinite wait and 0 for no wait.
The appropriate LOCK clause string.
Does this dialect support referencing the table being mutated in a subquery. The "table being mutated" is the table referenced in an UPDATE or a DELETE query. And so can that table then be referenced in a subquery of said UPDATE/DELETE query.
True if this dialect allows references the mutating table from a subquery.