Uses of Class
org.h2.table.Column

Packages that use Column

Package	Description
org.h2.command	This package contains the parser and the base classes for prepared SQL statements.
org.h2.command.ddl	Contains DDL (data definition language) and related SQL statements.
org.h2.command.dml	Contains DML (data manipulation language) and related SQL statements.
org.h2.command.query	Contains queries.
org.h2.constraint	Database constraints such as check constraints, unique constraints, and referential constraints.
org.h2.expression	Expressions include mathematical operations, simple values, and others.
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.table	Classes related to a table and table meta data.

Uses of Column in org.h2.command

Methods in org.h2.command with parameters of type Column

Modifier and Type	Method	Description
static AlterTableAddConstraint	Parser.newPrimaryKeyConstraintCommand(SessionLocal session, Schema schema, String tableName, Column column)	Create a new alter table command.

Uses of Column in org.h2.command.ddl

Fields in org.h2.command.ddl with type parameters of type Column

Modifier and Type	Field	Description
ArrayList<Column>	CreateTableData.columns	The column list.

Methods in org.h2.command.ddl that return types with arguments of type Column

Modifier and Type	Method	Description
ArrayList<Column>	CreateTable.getColumns()

Methods in org.h2.command.ddl with parameters of type Column

Modifier and Type	Method	Description
void	AlterTableAlterColumn.addColumn(Column column)
abstract void	CommandWithColumns.addColumn(Column column)	Add a column to this table.
void	CreateTable.addColumn(Column column)
void	AlterSequence.setColumn(Column column, Boolean always)	Set the column
void	AlterTableAlterColumn.setNewColumn(Column newColumn)
void	AlterTableAlterColumn.setOldColumn(Column oldColumn)

Method parameters in org.h2.command.ddl with type arguments of type Column

Modifier and Type	Method	Description
protected void	CommandWithColumns.changePrimaryKeysToNotNull(ArrayList<Column> columns)	For the given list of columns, disable "nullable" for those columns that are primary key columns.
static void	AlterDomain.forAllDependencies(SessionLocal session, Domain domain, BiPredicate<Domain,Column> columnProcessor, BiPredicate<Domain,Domain> domainProcessor, boolean recompileExpressions)	Processes all columns and domains that use the specified domain.
protected ArrayList<Sequence>	CommandWithColumns.generateSequences(ArrayList<Column> columns, boolean temporary)	For the given list of columns, create sequences for identity columns (if needed), and then get the list of all sequences of the columns.
void	AlterTableAlterColumn.setColumnsToRemove(ArrayList<Column> columnsToRemove)

Uses of Column in org.h2.command.dml

Methods in org.h2.command.dml with parameters of type Column

Modifier and Type	Method	Description
void	Insert.addAssignmentForDuplicate(Column column, Expression expression)	Keep a collection of the columns to pass to update if a duplicate key happens, for MySQL-style INSERT ...
void	SetClauseList.addSingle(Column column, Expression expression)	Add a single column.
void	Insert.setColumns(Column[] columns)
void	Merge.setColumns(Column[] columns)
void	Merge.setKeys(Column[] keys)

Method parameters in org.h2.command.dml with type arguments of type Column

Modifier and Type	Method	Description
void	SetClauseList.addMultiple(ArrayList<Column> columns, Expression expression)	Add multiple columns.

Constructors in org.h2.command.dml with parameters of type Column

Modifier	Constructor	Description
	WhenNotMatched(Column[] columns, Boolean overridingSystem, Expression[] values)

Uses of Column in org.h2.command.query

Methods in org.h2.command.query that return Column

Modifier and Type	Method	Description
Column	SelectListColumnResolver.findColumn(String name)
Column[]	SelectListColumnResolver.getColumns()

Methods in org.h2.command.query that return types with arguments of type Column

Modifier and Type	Method	Description
ArrayList<Column>	AllColumnsForPlan.get(Table table)	Used by index to calculate the cost of a scan.

Methods in org.h2.command.query with parameters of type Column

Modifier and Type	Method	Description
void	AllColumnsForPlan.add(Column newCol)	Called by ExpressionVisitor.
Value	SelectListColumnResolver.getValue(Column column)
static void	TableValueConstructor.getVisibleResult(SessionLocal session, ResultTarget result, Column[] columns, ArrayList<ArrayList<Expression>> rows)	Appends visible columns of all rows to the specified result.
Expression	SelectListColumnResolver.optimize(ExpressionColumn expressionColumn, Column column)
Table	Query.toTable(String alias, Column[] columnTemplates, ArrayList<Parameter> parameters, boolean forCreateView, Query topQuery)	Converts this query to a table or a view.
Table	TableValueConstructor.toTable(String alias, Column[] columnTemplates, ArrayList<Parameter> parameters, boolean forCreateView, Query topQuery)

Uses of Column in org.h2.constraint

Methods in org.h2.constraint that return Column

Modifier and Type	Method	Description
Column	DomainColumnResolver.findColumn(String name)
Column[]	DomainColumnResolver.getColumns()

Methods in org.h2.constraint that return types with arguments of type Column

Modifier and Type	Method	Description
abstract HashSet<Column>	Constraint.getReferencedColumns(Table table)	Get all referenced columns.
HashSet<Column>	ConstraintCheck.getReferencedColumns(Table table)
HashSet<Column>	ConstraintDomain.getReferencedColumns(Table table)
HashSet<Column>	ConstraintReferential.getReferencedColumns(Table table)
HashSet<Column>	ConstraintUnique.getReferencedColumns(Table table)

Methods in org.h2.constraint with parameters of type Column

Modifier and Type	Method	Description
Value	DomainColumnResolver.getValue(Column col)

Uses of Column in org.h2.expression

Methods in org.h2.expression that return Column

Modifier and Type	Method	Description
Column	ExpressionColumn.getColumn()

Methods in org.h2.expression that return types with arguments of type Column

Modifier and Type	Method	Description
HashMap<Column, ExpressionColumn>	Wildcard.mapExceptColumns()	Returns map of excluded table columns to expression columns and validates that all columns are resolved and not duplicated.

Methods in org.h2.expression with parameters of type Column

Modifier and Type	Method	Description
void	Parameter.setColumn(Column column)

Method parameters in org.h2.expression with type arguments of type Column

Modifier and Type	Method	Description
static ExpressionVisitor	ExpressionVisitor.getColumnsVisitor(HashSet<Column> columns, Table table)	Create a new visitor to get all referenced columns.

Constructors in org.h2.expression with parameters of type Column

Modifier	Constructor	Description
	ExpressionColumn(Database database, Column column)	Creates a new column reference for metadata of queries; should not be used as normal expression.

Uses of Column in org.h2.expression.function

Constructors in org.h2.expression.function with parameters of type Column

Modifier	Constructor	Description
	CastSpecification(Expression arg, Column column)

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

Method parameters in org.h2.expression.function.table with type arguments of type Column

Modifier and Type	Method	Description
void	ArrayTableFunction.setColumns(ArrayList<Column> columns)

Uses of Column in org.h2.index

Fields in org.h2.index declared as Column

Modifier and Type	Field	Description
protected Column[]	Index.columns	Table columns used in this index.

Methods in org.h2.index that return Column

Modifier and Type	Method	Description
Column	IndexCondition.getColumn()	Get the referenced column.
final Column[]	Index.getColumns()	Get the indexed columns.

Methods in org.h2.index with parameters of type Column

Modifier and Type	Method	Description
int	Index.getColumnIndex(Column col)	Get the index of a column in the list of index columns
int	MetaIndex.getColumnIndex(Column col)
boolean	Index.isFirstColumn(Column column)	Check if the given column is the first for this index
boolean	MetaIndex.isFirstColumn(Column column)

Uses of Column in org.h2.mode

Constructors in org.h2.mode with parameters of type Column

Modifier	Constructor	Description
	OnDuplicateKeyValues(Column column, Update update)

Uses of Column in org.h2.mvstore.db

Methods in org.h2.mvstore.db that return Column

Modifier and Type	Method	Description
Column	MVTable.getRowIdColumn()

Methods in org.h2.mvstore.db with parameters of type Column

Modifier and Type	Method	Description
int	MVDelegateIndex.getColumnIndex(Column col)
int	MVPrimaryIndex.getColumnIndex(Column col)
static long	MVSpatialIndex.getCostRangeIndex(int[] masks, Column[] columns)	Compute spatial index cost
boolean	MVDelegateIndex.isFirstColumn(Column column)
boolean	MVPrimaryIndex.isFirstColumn(Column column)

Uses of Column in org.h2.result

Methods in org.h2.result that return Column

Modifier and Type	Method	Description
Column	SortOrder.getColumn(int index, TableFilter filter)	Get the column for the given table filter, if the sort column is for this filter.

Uses of Column in org.h2.table

Fields in org.h2.table declared as Column

Modifier and Type	Field	Description
Column	IndexColumn.column	The column, or null if not set.
protected Column[]	Table.columns	The columns of this table.

Methods in org.h2.table that return Column

Modifier and Type	Method	Description
protected final Column	MetaTable.column(String name, TypeInfo type)	Creates a column with the specified name and data type.
Column	ColumnResolver.findColumn(String name)	Get the column with the specified name.
Column	Table.findColumn(String columnName)	Get the column with the given name if it exists.
Column	TableFilter.findColumn(String name)
Column	Column.getClone()
Column	Table.getColumn(int index)	Get the column at the given index.
Column	Table.getColumn(String columnName)	Get the column with the given name.
Column	Table.getColumn(String columnName, boolean ifExists)	Get the column with the given name.
Column	TableFilter.getColumn(String columnName, boolean ifExists)	Get the column with the given name.
Column[]	ColumnResolver.getColumns()	Get the column list.
Column[]	Table.getColumns()
Column[]	TableFilter.getColumns()
Column	Table.getIdentityColumn()	Returns first identity column, or null.
default Column	ColumnResolver.getRowIdColumn()	Get the row id pseudo column, if there is one.
Column	Table.getRowIdColumn()	Get the row id column if this table has one.
Column	TableFilter.getRowIdColumn()
default Column[]	ColumnResolver.getSystemColumns()	Get the list of system columns, if any.
Column[]	TableFilter.getSystemColumns()	Get the system columns that this table understands.

Methods in org.h2.table that return types with arguments of type Column

Modifier and Type	Method	Description
static List<Column>	TableView.createQueryColumnTemplateList(String[] cols, Query theQuery, String[] querySQLOutput)	Creates a list of column templates from a query (usually from WITH query, but could be any query)
LinkedHashMap<Column,Column>	TableFilter.getCommonJoinColumns()	Returns common join columns map.
LinkedHashMap<Column,Column>	TableFilter.getCommonJoinColumns()	Returns common join columns map.

Methods in org.h2.table with parameters of type Column

Modifier and Type	Method	Description
void	TableFilter.addCommonJoinColumns(Column leftColumn, Column replacementColumn, TableFilter replacementFilter)	Add a column to the common join column list for a left table filter.
void	TableFilter.addCommonJoinColumnToExclude(Column columnToExclude)	Add an excluded column to the common join column list.
void	Column.copy(Column source)	Copy the data of the source column into the current column.
static TableView	TableView.createTableViewMaybeRecursive(Schema schema, int id, String name, String querySQL, ArrayList<Parameter> parameters, Column[] columnTemplates, SessionLocal session, boolean literalsChecked, boolean isTableExpression, boolean isTemporary, Database db)	Create a view.
static TableView	TableView.createTempView(SessionLocal session, User owner, String name, Column[] columnTemplates, Query query, Query topQuery)	Create a temporary view out of the given query.
default String	ColumnResolver.getColumnName(Column column)	Get the name of the specified column.
String	TableFilter.getColumnName(Column column)
Index	Table.getIndexForColumn(Column column, boolean needGetFirstOrLast, boolean needFindNext)	Get the index that has the given column as the first element.
Value	ColumnResolver.getValue(Column column)	Get the value for the given column.
Value	TableFilter.getValue(Column column)
boolean	TableFilter.isCommonJoinColumnToExclude(Column c)	Check if the given column is an excluded common join column.
boolean	Column.isWideningConversion(Column newColumn)	Check whether the new column is of the same type and not more restricted than this column.
default Expression	ColumnResolver.optimize(ExpressionColumn expressionColumn, Column column)	Get the expression that represents this column.
void	Table.renameColumn(Column column, String newName)	Rename a column of this table.
void	TableView.replace(String querySQL, Column[] newColumnTemplates, SessionLocal session, boolean recursive, boolean force, boolean literalsChecked)	Try to replace the SQL statement of the view and re-compile this and all dependent views.
protected void	Table.setColumns(Column[] columns)
static IndexColumn[]	IndexColumn.wrap(Column[] columns)	Create an array of index columns from a list of columns.
static StringBuilder	Column.writeColumns(StringBuilder builder, Column[] columns, int sqlFlags)	Appends the specified columns to the specified builder.
static StringBuilder	Column.writeColumns(StringBuilder builder, Column[] columns, String separator, String suffix, int sqlFlags)	Appends the specified columns to the specified builder.

Method parameters in org.h2.table with type arguments of type Column

Modifier and Type	Method	Description
static Table	TableView.createShadowTableForRecursiveTableExpression(boolean isTemporary, SessionLocal targetSession, String cteViewName, Schema schema, List<Column> columns, Database db)	Create a table for a recursive query.
void	Table.dropMultipleColumnsConstraintsAndIndexes(SessionLocal session, ArrayList<Column> columnsToDrop)	Check that these columns are not referenced by a multi-column constraint or multi-column index.

Constructors in org.h2.table with parameters of type Column

Modifier	Constructor	Description
	IndexColumn(Column column)	Creates a new instance with the specified column.
	TableValueConstructorTable(Schema schema, SessionLocal session, Column[] columns, ArrayList<ArrayList<Expression>> rows)
	TableView(Schema schema, int id, String name, String querySQL, ArrayList<Parameter> params, Column[] columnTemplates, SessionLocal session, boolean allowRecursive, boolean literalsChecked, boolean isTableExpression, boolean isTemporary)