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.
class	MergeUsing.WhenMatchedThenDelete
class	MergeUsing.WhenMatchedThenUpdate
class	MergeUsing.WhenNotMatched
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
class	Comment	Represents a database object comment.
class	DbObject	A database object such as a table, an index, or a user.
class	Right	An access right.
class	RightOwner	A right owner (sometimes called principal).
class	Role	Represents a role.
class	Setting	A persistent database setting.
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
class	Alias	A column alias as in SELECT 'Hello' AS NAME ...
class	ArrayConstructorByQuery	Array value constructor by query.
class	ArrayElementReference	Array element reference.
class	BinaryOperation	A mathematical expression, or string concatenation.
class	CompatibilityDatePlusTimeOperation	A compatibility mathematical operation with datetime values.
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.
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.
class	ExpressionColumn	A column reference expression that represents a column of a table or view.
class	ExpressionList	A list of expressions, as in (ID, NAME).
class	FieldReference	Field reference.
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.
class	Parameter	A parameter of a prepared statement.
class	Rownum	Represents the ROWNUM function.
class	SearchedCase	A searched case.
class	SequenceValue	Wraps a sequence when used in a statement.
class	SimpleCase	A simple case.
class	Subquery	A query returning a single value.
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.
class	Variable	A user-defined variable, for example: @ID.
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
class	BetweenPredicate	BETWEEN predicate.
class	BooleanTest	Boolean test (IS [NOT] { TRUE | FALSE | UNKNOWN }).
class	CompareLike	Pattern matching comparison expression: WHERE NAME LIKE ?
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.
class	ConditionIn	An 'in' condition with a list of values, as in WHERE NAME IN(...)
class	ConditionInConstantSet	Used for optimised IN(...) queries where the contents of the IN list are all constant and of the same type.
class	ConditionInParameter	A condition with parameter as = ANY(?).
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 ...)
class	IsJsonPredicate	IS JSON predicate.
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.
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
class	ArrayFunction	An array function.
class	BitFunction	A bitwise function.
class	CardinalityExpression	Cardinality expression.
class	CastSpecification	A cast specification.
class	CoalesceFunction	A COALESCE, GREATEST, or LEAST function.
class	CompatibilitySequenceValueFunction	NEXTVAL() and CURRVAL() compatibility functions.
class	CompressFunction	A COMPRESS or EXPAND function.
class	ConcatFunction	A CONCAT or CONCAT_WS function.
class	CryptFunction	An ENCRYPT or DECRYPT function.
class	CSVWriteFunction	A CSVWRITE function.
class	CurrentDateTimeValueFunction	Current datetime value function.
class	CurrentGeneralValueSpecification	Simple general value specifications.
class	DataTypeSQLFunction	DATA_TYPE_SQL() function.
class	DateTimeFormatFunction	A date-time format function.
class	DateTimeFunction	A date-time function.
class	DayMonthNameFunction	A DAYNAME() or MONTHNAME() function.
class	DBObjectFunction	DB_OBJECT_ID() and DB_OBJECT_SQL() functions.
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.
class	HashFunction	A HASH or ORA_HASH function.
class	JavaFunction	This class wraps a user-defined function.
class	JsonConstructorFunction	JSON constructor function.
class	LengthFunction	CHAR_LENGTH(), or OCTET_LENGTH() function.
class	MathFunction	A math function.
class	MathFunction1	A math function with one argument and DOUBLE PRECISION result.
class	MathFunction2	A math function with two arguments and DOUBLE PRECISION result.
class	NullIfFunction	A NULLIF function.
class	RandFunction	A RAND, SECURE_RAND, or RANDOM_UUID function.
class	RegexpFunction	A regular expression function.
class	SessionControlFunction	An ABORT_SESSION() or CANCEL_SESSION() function.
class	SetFunction	A SET function.
class	SignalFunction	A SIGNAL function.
class	SoundexFunction	A SOUNDEX or DIFFERENCE function.
class	StringFunction	An string function with multiple arguments.
class	StringFunction1	A string function with one argument.
class	StringFunction2	A string function with two arguments.
class	SubstringFunction	A SUBSTRING function.
class	SysInfoFunction	Database or session information function.
class	TableInfoFunction	A table information function.
class	ToCharFunction	Emulates Oracle's TO_CHAR function.
class	TrimFunction	A TRIM function.
class	TruncateValueFunction	A TRUNCATE_VALUE function.
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
class	ArrayTableFunction	A table value function.
class	CSVReadFunction	A CSVREAD function.
class	JavaTableFunction	This class wraps a user-defined function.
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
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.
class	FunctionsMSSQLServer	Functions for Mode.ModeEnum.MSSQLServer compatibility mode.
class	FunctionsMySQL	This class implements some MySQL-specific functions.
class	FunctionsOracle	Functions for Mode.ModeEnum.Oracle compatibility mode.
class	FunctionsPostgreSQL	Functions for Mode.ModeEnum.PostgreSQL compatibility mode.
class	ModeFunction	Base class for mode-specific functions.
class	OnDuplicateKeyValues	VALUES(column) function for ON DUPLICATE KEY UPDATE clause.
class	PgCatalogSchema	pg_catalog schema.
class	PgCatalogTable	This class is responsible to build the pg_catalog tables.
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.
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.
class	Sparse	Class Sparse.

Uses of HasSQL in org.h2.schema

Classes in org.h2.schema that implement HasSQL

Modifier and Type	Class	Description
class	Constant	A user-defined constant as created by the SQL statement CREATE CONSTANT
class	Domain	Represents a domain.
class	FunctionAlias	Represents a user-defined function, or alias.
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.
class	Sequence	A sequence is created using the statement CREATE SEQUENCE
class	TriggerObject	A trigger is created using the statement CREATE TRIGGER
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
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.
class	InformationSchemaTable	This class is responsible to build the INFORMATION_SCHEMA tables.
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.
class	ExtTypeInfoEnum	Extended parameters of the ENUM data type.
class	ExtTypeInfoGeometry	Extended parameters of the GEOMETRY data type.
class	ExtTypeInfoNumeric	Extended parameters of the NUMERIC data type.
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.
class	ValueArray	Implementation of the ARRAY data type.
(package private) class	ValueBigDecimalBase	Base class for BigDecimal-based values.
class	ValueBigint	Implementation of the BIGINT data type.
class	ValueBinary	Implementation of the BINARY data type.
class	ValueBlob	Implementation of the BINARY LARGE OBJECT data type.
class	ValueBoolean	Implementation of the BOOLEAN data type.
(package private) class	ValueBytesBase	Base implementation of byte array based data types.
class	ValueChar	Implementation of the CHARACTER data type.
class	ValueClob	Implementation of the CHARACTER LARGE OBJECT data type.
class	ValueCollectionBase	Base class for ARRAY and ROW values.
class	ValueDate	Implementation of the DATE data type.
class	ValueDecfloat	Implementation of the DECFLOAT data type.
class	ValueDouble	Implementation of the DOUBLE PRECISION data type.
class	ValueEnum	ENUM value.
class	ValueEnumBase	Base implementation of the ENUM data type.
class	ValueGeometry	Implementation of the GEOMETRY data type.
class	ValueInteger	Implementation of the INTEGER data type.
class	ValueInterval	Implementation of the INTERVAL data type.
class	ValueJavaObject	Implementation of the JAVA_OBJECT data type.
class	ValueJson	Implementation of the JSON data type.
class	ValueLob	A implementation of the BINARY LARGE OBJECT and CHARACTER LARGE OBJECT data types.
class	ValueNull	Implementation of NULL.
class	ValueNumeric	Implementation of the NUMERIC data type.
class	ValueReal	Implementation of the REAL data type.
class	ValueRow	Row value.
class	ValueSmallint	Implementation of the SMALLINT data type.
(package private) class	ValueStringBase	Base implementation of String based data types.
class	ValueTime	Implementation of the TIME data type.
class	ValueTimestamp	Implementation of the TIMESTAMP data type.
class	ValueTimestampTimeZone	Implementation of the TIMESTAMP WITH TIME ZONE data type.
class	ValueTimeTimeZone	Implementation of the TIME WITH TIME ZONE data type.
class	ValueTinyint	Implementation of the TINYINT data type.
class	ValueUuid	Implementation of the UUID data type.
class	ValueVarbinary	Implementation of the BINARY VARYING data type.
class	ValueVarchar	Implementation of the CHARACTER VARYING data type.
class	ValueVarcharIgnoreCase	Implementation of the VARCHAR_IGNORECASE data type.