Uses of Interface
org.h2.util.HasSQL

Packages that use HasSQL

Package	Description
org.h2.command.dml	Contains DML (data manipulation language) and related SQL statements.
org.h2.constraint	Database constraints such as check constraints, unique constraints, and referential constraints.
org.h2.engine	Contains high level classes of the database and classes that don't fit in another sub-package.
org.h2.expression	Expressions include mathematical operations, simple values, and others.
org.h2.expression.aggregate	Aggregate functions.
org.h2.expression.analysis	Base classes for data analysis operations and implementations of window functions.
org.h2.expression.condition	Condition expressions.
org.h2.expression.function	Functions.
org.h2.expression.function.table	Table value functions.
org.h2.index	Various table index implementations, as well as cursors to navigate in an index.
org.h2.mode	Utility classes for compatibility with other database, for example MySQL.
org.h2.mvstore.db	Helper classes to use the MVStore in the H2 database.
org.h2.result	Implementation of row and internal result sets.
org.h2.schema	Schema implementation and objects that are stored in a schema (for example, sequences and constants).
org.h2.table	Classes related to a table and table meta data.
org.h2.value	Data type and value implementations.

Uses of HasSQL in org.h2.command.dml

Classes in org.h2.command.dml that implement HasSQL

Modifier and Type	Class	Description
class	MergeUsing.When	Abstract WHEN command of the MERGE statement.
final class	MergeUsing.WhenMatchedThenDelete
final class	MergeUsing.WhenMatchedThenUpdate
final class	MergeUsing.WhenNotMatched
final class	SetClauseList	Set clause list.

Uses of HasSQL in org.h2.constraint

Classes in org.h2.constraint that implement HasSQL

Modifier and Type	Class	Description
class	Constraint	The base class for constraint checking.
class	ConstraintCheck	A check constraint.
class	ConstraintDomain	A domain constraint.
class	ConstraintReferential	A referential constraint.
class	ConstraintUnique	A unique constraint.

Uses of HasSQL in org.h2.engine

Classes in org.h2.engine that implement HasSQL

Modifier and Type	Class	Description
final class	Comment	Represents a database object comment.
class	DbObject	A database object such as a table, an index, or a user.
final class	Right	An access right.
class	RightOwner	A right owner (sometimes called principal).
final class	Role	Represents a role.
final class	Setting	A persistent database setting.
final class	User	Represents a user object.

Uses of HasSQL in org.h2.expression

Classes in org.h2.expression that implement HasSQL

Modifier and Type	Class	Description
final class	Alias	A column alias as in SELECT 'Hello' AS NAME ...
final class	ArrayConstructorByQuery	Array value constructor by query.
final class	ArrayElementReference	Array element reference.
class	BinaryOperation	A mathematical expression, or string concatenation.
class	CompatibilityDatePlusTimeOperation	A compatibility mathematical operation with datetime values.
final class	ConcatenationOperation	Character string concatenation as in 'Hello' || 'World', binary string concatenation as in X'01' || X'AB' or an array concatenation as in ARRAY[1, 2] || 3.
final class	DomainValueExpression	An expression representing a value for domain constraint.
class	Expression	An expression is a operation, a value, or a function in a query.
final class	ExpressionColumn	A column reference expression that represents a column of a table or view.
final class	ExpressionList	A list of expressions, as in (ID, NAME).
final class	FieldReference	Field reference.
final class	Format	A format clause such as FORMAT JSON.
class	IntervalOperation	A mathematical operation with intervals.
class	Operation0	Operation without subexpressions.
class	Operation1	Operation with one argument.
class	Operation1_2	Operation with one or two arguments.
class	Operation2	Operation with two arguments.
class	OperationN	Operation with many arguments.
final class	Parameter	A parameter of a prepared statement.
final class	Rownum	Represents the ROWNUM function.
final class	SearchedCase	A searched case.
final class	SequenceValue	Wraps a sequence when used in a statement.
final class	SimpleCase	A simple case.
final class	Subquery	A query returning a single value.
final class	TimeZoneOperation	A time zone specification (AT { TIME ZONE | LOCAL }).
class	TypedValueExpression	An expression representing a constant value with a type cast.
class	UnaryOperation	Unary operation.
class	ValueExpression	An expression representing a constant value.
final class	Variable	A user-defined variable, for example: @ID.
final class	Wildcard	A wildcard expression as in SELECT * FROM TEST.

Uses of HasSQL in org.h2.expression.aggregate

Classes in org.h2.expression.aggregate that implement HasSQL

Modifier and Type	Class	Description
class	AbstractAggregate	A base class for aggregate functions.
class	Aggregate	Implements the integrated aggregate functions, such as COUNT, MAX, SUM.
class	JavaAggregate	This class wraps a user-defined aggregate.

Uses of HasSQL in org.h2.expression.analysis

Classes in org.h2.expression.analysis that implement HasSQL

Modifier and Type	Class	Description
class	DataAnalysisOperation	A base class for data analysis operations such as aggregates and window functions.
class	WindowFunction	A window function.

Uses of HasSQL in org.h2.expression.condition

Classes in org.h2.expression.condition that implement HasSQL

Modifier and Type	Class	Description
final class	BetweenPredicate	BETWEEN predicate.
final class	BooleanTest	Boolean test (IS [NOT] { TRUE | FALSE | UNKNOWN }).
final class	CompareLike	Pattern matching comparison expression: WHERE NAME LIKE ?
final class	Comparison	Example comparison expressions are ID=1, NAME=NAME, NAME IS NULL.
(package private) class	Condition	Represents a condition returning a boolean value, or NULL.
class	ConditionAndOr	An 'and' or 'or' condition as in WHERE ID=1 AND NAME=?
class	ConditionAndOrN	An 'and' or 'or' condition as in WHERE ID=1 AND NAME=? with N operands.
final class	ConditionIn	An 'in' condition with a list of values, as in WHERE NAME IN(...)
final class	ConditionInConstantSet	Used for optimised IN(...) queries where the contents of the IN list are all constant and of the same type.
final class	ConditionInParameter	A condition with parameter as = ANY(?).
final class	ConditionInQuery	An IN() condition with a subquery, as in WHERE ID IN(SELECT ...)
class	ConditionLocalAndGlobal	A global condition or combination of local and global conditions.
class	ConditionNot	A NOT condition.
class	ExistsPredicate	Exists predicate as in EXISTS(SELECT ...)
final class	IsJsonPredicate	IS JSON predicate.
final class	NullPredicate	Null predicate (IS [NOT] NULL).
(package private) class	PredicateWithSubquery	Base class for predicates with a subquery.
class	SimplePredicate	Base class for simple predicates.
final class	TypePredicate	Type predicate (IS [NOT] OF).
class	UniquePredicate	Unique predicate as in UNIQUE(SELECT ...)

Uses of HasSQL in org.h2.expression.function

Classes in org.h2.expression.function that implement HasSQL

Modifier and Type	Class	Description
final class	ArrayFunction	An array function.
final class	BitFunction	A bitwise function.
final class	CardinalityExpression	Cardinality expression.
final class	CastSpecification	A cast specification.
final class	CoalesceFunction	A COALESCE, GREATEST, or LEAST function.
final class	CompatibilitySequenceValueFunction	NEXTVAL() and CURRVAL() compatibility functions.
final class	CompressFunction	A COMPRESS or EXPAND function.
final class	ConcatFunction	A CONCAT or CONCAT_WS function.
final class	CryptFunction	An ENCRYPT or DECRYPT function.
final class	CSVWriteFunction	A CSVWRITE function.
final class	CurrentDateTimeValueFunction	Current datetime value function.
final class	CurrentGeneralValueSpecification	Simple general value specifications.
final class	DataTypeSQLFunction	DATA_TYPE_SQL() function.
final class	DateTimeFormatFunction	A date-time format function.
final class	DateTimeFunction	A date-time function.
final class	DayMonthNameFunction	A DAYNAME() or MONTHNAME() function.
final class	DBObjectFunction	DB_OBJECT_ID() and DB_OBJECT_SQL() functions.
final class	FileFunction	A FILE_READ or FILE_WRITE function.
class	Function0_1	Function with one optional argument.
class	Function1	Function with one argument.
class	Function1_2	Function with two arguments.
class	Function2	Function with two arguments.
class	FunctionN	Function with many arguments.
final class	HashFunction	A HASH or ORA_HASH function.
final class	JavaFunction	This class wraps a user-defined function.
final class	JsonConstructorFunction	JSON constructor function.
final class	LengthFunction	CHAR_LENGTH(), or OCTET_LENGTH() function.
final class	MathFunction	A math function.
final class	MathFunction1	A math function with one argument and DOUBLE PRECISION result.
final class	MathFunction2	A math function with two arguments and DOUBLE PRECISION result.
final class	NullIfFunction	A NULLIF function.
final class	RandFunction	A RAND, SECURE_RAND, or RANDOM_UUID function.
final class	RegexpFunction	A regular expression function.
final class	SessionControlFunction	An ABORT_SESSION() or CANCEL_SESSION() function.
final class	SetFunction	A SET function.
final class	SignalFunction	A SIGNAL function.
final class	SoundexFunction	A SOUNDEX or DIFFERENCE function.
final class	StringFunction	An string function with multiple arguments.
final class	StringFunction1	A string function with one argument.
final class	StringFunction2	A string function with two arguments.
final class	SubstringFunction	A SUBSTRING function.
final class	SysInfoFunction	Database or session information function.
final class	TableInfoFunction	A table information function.
final class	ToCharFunction	Emulates Oracle's TO_CHAR function.
final class	TrimFunction	A TRIM function.
final class	TruncateValueFunction	A TRUNCATE_VALUE function.
final class	XMLFunction	An XML function.

Uses of HasSQL in org.h2.expression.function.table

Classes in org.h2.expression.function.table that implement HasSQL

Modifier and Type	Class	Description
final class	ArrayTableFunction	A table value function.
final class	CSVReadFunction	A CSVREAD function.
final class	JavaTableFunction	This class wraps a user-defined function.
final class	LinkSchemaFunction	A LINK_SCHEMA function.
class	TableFunction	A table value function.

Uses of HasSQL in org.h2.index

Classes in org.h2.index that implement HasSQL

Modifier and Type	Class	Description
class	DualIndex	An index for the DUAL table.
class	Index	An index.
class	LinkedIndex	A linked index is a index for a linked (remote) table.
class	MetaIndex	The index implementation for meta data tables.
class	RangeIndex	An index for the SYSTEM_RANGE table.
class	ViewIndex	This object represents a virtual index for a query.
class	VirtualConstructedTableIndex	An index for a virtual table that returns a result set.
class	VirtualTableIndex	An base class for indexes of virtual tables.

Uses of HasSQL in org.h2.mode

Classes in org.h2.mode that implement HasSQL

Modifier and Type	Class	Description
final class	FunctionsDB2Derby	Functions for Mode.ModeEnum.DB2 and Mode.ModeEnum.Derby compatibility modes.
class	FunctionsLegacy	This class implements some legacy functions not available in Regular mode.
final class	FunctionsMSSQLServer	Functions for Mode.ModeEnum.MSSQLServer compatibility mode.
final class	FunctionsMySQL	This class implements some MySQL-specific functions.
final class	FunctionsOracle	Functions for Mode.ModeEnum.Oracle compatibility mode.
final class	FunctionsPostgreSQL	Functions for Mode.ModeEnum.PostgreSQL compatibility mode.
class	ModeFunction	Base class for mode-specific functions.
final class	OnDuplicateKeyValues	VALUES(column) function for ON DUPLICATE KEY UPDATE clause.
final class	PgCatalogSchema	pg_catalog schema.
final class	PgCatalogTable	This class is responsible to build the pg_catalog tables.
final class	Regclass	A ::regclass expression.

Uses of HasSQL in org.h2.mvstore.db

Classes in org.h2.mvstore.db that implement HasSQL

Modifier and Type	Class	Description
class	MVDelegateIndex	An index that delegates indexing to another index.
class	MVIndex<K,V>	An index that stores the data in an MVStore.
class	MVPrimaryIndex	A table stored in a MVStore.
final class	MVSecondaryIndex	An index stored in a MVStore.
class	MVSpatialIndex	This is an index based on a MVRTreeMap.
class	MVTable	A table stored in a MVStore.
class	SpatialKey	A unique spatial key.

Uses of HasSQL in org.h2.result

Classes in org.h2.result that implement HasSQL

Modifier and Type	Class	Description
class	DefaultRow	The default implementation of a row in a table.
class	Row	Represents a row in a table.
class	SearchRow	The base class for rows stored in a table, and for partial rows stored in the index.
class	SimpleRowValue	A simple row that contains data for only one column.
final class	Sparse	Class Sparse.

Uses of HasSQL in org.h2.schema

Classes in org.h2.schema that implement HasSQL

Modifier and Type	Class	Description
final class	Constant	A user-defined constant as created by the SQL statement CREATE CONSTANT
final class	Domain	Represents a domain.
final class	FunctionAlias	Represents a user-defined function, or alias.
final class	InformationSchema	Information schema.
class	MetaSchema	Meta data schema.
class	Schema	A schema as created by the SQL statement CREATE SCHEMA
class	SchemaObject	Any database object that is stored in a schema.
final class	Sequence	A sequence is created using the statement CREATE SEQUENCE
final class	TriggerObject	A trigger is created using the statement CREATE TRIGGER
final class	UserAggregate	Represents a user-defined aggregate function.
class	UserDefinedFunction	User-defined Java function or aggregate function.

Uses of HasSQL in org.h2.table

Classes in org.h2.table that implement HasSQL

Modifier and Type	Class	Description
final class	Column	This class represents a column in a table.
class	DataChangeDeltaTable	A data change delta table.
class	DualTable	The DUAL table for selects without a FROM clause.
class	FunctionTable	A table backed by a system or user-defined function that returns a result set.
final class	InformationSchemaTable	This class is responsible to build the INFORMATION_SCHEMA tables.
final class	InformationSchemaTableLegacy	This class is responsible to build the legacy variant of INFORMATION_SCHEMA tables.
class	MetaTable	This class is responsible to build the database meta data pseudo tables.
class	RangeTable	The table SYSTEM_RANGE is a virtual table that generates incrementing numbers with a given start end point.
class	Table	This is the base class for most tables.
class	TableBase	The base class of a regular table, or a user defined table.
class	TableLink	A linked table contains connection information for a table accessible by JDBC.
class	TableSynonym	Synonym for an existing table or view.
class	TableValueConstructorTable	A table for table value constructor.
class	TableView	A view is a virtual table that is defined by a query.
class	VirtualConstructedTable	A base class for virtual tables that construct all their content at once.
class	VirtualTable	A base class for virtual tables.

Uses of HasSQL in org.h2.value

Classes in org.h2.value that implement HasSQL

Modifier and Type	Class	Description
class	ExtTypeInfo	Extended parameters of a data type.
final class	ExtTypeInfoEnum	Extended parameters of the ENUM data type.
final class	ExtTypeInfoGeometry	Extended parameters of the GEOMETRY data type.
final class	ExtTypeInfoNumeric	Extended parameters of the NUMERIC data type.
final class	ExtTypeInfoRow	Extended parameters of the ROW data type.
class	TypeInfo	Data type with parameters.
class	Value	This is the base class for all value classes.
final class	ValueArray	Implementation of the ARRAY data type.
(package private) class	ValueBigDecimalBase	Base class for BigDecimal-based values.
final class	ValueBigint	Implementation of the BIGINT data type.
final class	ValueBinary	Implementation of the BINARY data type.
final class	ValueBlob	Implementation of the BINARY LARGE OBJECT data type.
final class	ValueBoolean	Implementation of the BOOLEAN data type.
(package private) class	ValueBytesBase	Base implementation of byte array based data types.
final class	ValueChar	Implementation of the CHARACTER data type.
final class	ValueClob	Implementation of the CHARACTER LARGE OBJECT data type.
class	ValueCollectionBase	Base class for ARRAY and ROW values.
final class	ValueDate	Implementation of the DATE data type.
final class	ValueDecfloat	Implementation of the DECFLOAT data type.
final class	ValueDouble	Implementation of the DOUBLE PRECISION data type.
final class	ValueEnum	ENUM value.
class	ValueEnumBase	Base implementation of the ENUM data type.
final class	ValueGeometry	Implementation of the GEOMETRY data type.
final class	ValueInteger	Implementation of the INTEGER data type.
final class	ValueInterval	Implementation of the INTERVAL data type.
final class	ValueJavaObject	Implementation of the JAVA_OBJECT data type.
final class	ValueJson	Implementation of the JSON data type.
class	ValueLob	A implementation of the BINARY LARGE OBJECT and CHARACTER LARGE OBJECT data types.
final class	ValueNull	Implementation of NULL.
final class	ValueNumeric	Implementation of the NUMERIC data type.
final class	ValueReal	Implementation of the REAL data type.
final class	ValueRow	Row value.
final class	ValueSmallint	Implementation of the SMALLINT data type.
(package private) class	ValueStringBase	Base implementation of String based data types.
final class	ValueTime	Implementation of the TIME data type.
final class	ValueTimestamp	Implementation of the TIMESTAMP data type.
final class	ValueTimestampTimeZone	Implementation of the TIMESTAMP WITH TIME ZONE data type.
final class	ValueTimeTimeZone	Implementation of the TIME WITH TIME ZONE data type.
final class	ValueTinyint	Implementation of the TINYINT data type.
final class	ValueUuid	Implementation of the UUID data type.
final class	ValueVarbinary	Implementation of the BINARY VARYING data type.
final class	ValueVarchar	Implementation of the CHARACTER VARYING data type.
final class	ValueVarcharIgnoreCase	Implementation of the VARCHAR_IGNORECASE data type.