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.jdbc.meta	Implementation of the JDBC database metadata API (package java.sql).
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 that return Column

Modifier and Type	Method	Description
private Column	Parser.columnIfTableExists(Schema schema, String tableName, String columnName, boolean ifTableExists, boolean ifExists)
private static Column	Parser.getColumnWithDomain(String columnName, Domain domain)
private Column	Parser.parseColumn(Table table)
private Column	Parser.parseColumnForTable(String columnName, boolean defaultNullable)
private Column[]	Parser.parseColumnList(Table table)
private Column	Parser.parseColumnWithType(String columnName)
private Column	Parser.readTableColumn(TableFilter filter)

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

Modifier and Type	Method	Description
private Expression	Parser.addJoinColumn(Expression on, TableFilter filter1, TableFilter filter2, Column column1, Column column2, boolean rightJoin)
private Prepared	Parser.getAlterTableAlterColumnDropDefaultExpression(Schema schema, String tableName, boolean ifTableExists, Column column, int type)
static AlterTableAddConstraint	Parser.newPrimaryKeyConstraintCommand(SessionLocal session, Schema schema, String tableName, Column column)	Create a new alter table command.
private Prepared	Parser.parseAlterTableAlterColumnIdentity(Schema schema, String tableName, boolean ifTableExists, Column column)
private Prepared	Parser.parseAlterTableAlterColumnSet(Schema schema, String tableName, boolean ifTableExists, boolean ifExists, String columnName, Column column)
private boolean	Parser.parseCompatibilityIdentity(Column column, Mode mode)
private void	Parser.parseCompatibilityIdentityOptions(Column column)
private void	Parser.parseInsertSet(Insert command, Table table, Column[] columns)
private void	Parser.readColumnConstraints(CommandWithColumns command, Schema schema, String tableName, Column column)

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

Modifier and Type	Method	Description
private TableView	Parser.createCTEView(String cteViewName, String querySQL, List<Column> columnTemplateList, boolean allowRecursiveQueryDetection, boolean addViewToSession, boolean isTemporary)

Uses of Column in org.h2.command.ddl

Fields in org.h2.command.ddl declared as Column

Modifier and Type	Field	Description
private Column	AlterSequence.column
private Column	AlterTableAlterColumn.newColumn
private Column	AlterTableAlterColumn.oldColumn

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

Modifier and Type	Field	Description
ArrayList<Column>	CreateTableData.columns	The column list.
private ArrayList<Column>	AlterTableAlterColumn.columnsToAdd
private ArrayList<Column>	AlterTableAlterColumn.columnsToRemove

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)
private static StringBuilder	AlterTableAlterColumn.addColumn(Column column, StringBuilder columnNames, StringBuilder columnValues)
abstract void	CommandWithColumns.addColumn(Column column)	Add a column to this table.
void	CreateTable.addColumn(Column column)
private void	AlterTableAlterColumn.checkClustering(Column c)
private Table	AlterTableAlterColumn.cloneTableStructure(Table table, Column[] columns, Database db, String tempName, ArrayList<Column> newColumns)
private void	AlterTableAlterColumn.convertIdentityColumn(Table table, Column c)
private boolean	AlterDomainExpressions.copyColumn(Domain domain, Column targetColumn)
private boolean	DropDomain.copyColumn(Domain domain, Column targetColumn)
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.
private Table	AlterTableAlterColumn.cloneTableStructure(Table table, Column[] columns, Database db, String tempName, ArrayList<Column> newColumns)
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.
private static boolean	AlterDomain.forTable(SessionLocal session, Domain domain, BiPredicate<Domain,Column> columnProcessor, boolean recompileExpressions, Table t)
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

Fields in org.h2.command.dml declared as Column

Modifier and Type	Field	Description
private Column[]	Insert.columns
private Column[]	Merge.columns
private Column[]	MergeUsing.WhenNotMatched.columns
private Column[]	Merge.keys

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

Modifier and Type	Field	Description
private HashMap<Column, Expression>	Insert.duplicateKeyAssignmentMap	For MySQL-style INSERT ...

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.
(package private) void	SetClauseList.SetSimple.getSQL(StringBuilder builder, int sqlFlags, Column column)
(package private) void	SetClauseList.UpdateAction.getSQL(StringBuilder builder, int sqlFlags, Column 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

Fields in org.h2.command.query declared as Column

Modifier and Type	Field	Description
private final Column[]	SelectListColumnResolver.columns

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

Modifier and Type	Field	Description
private HashMap<Table, ArrayList<Column>>	AllColumnsForPlan.map

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

Modifier and Type	Method	Description
Column	SelectListColumnResolver.findColumn(String name)
Column	TableValueConstructor.TableValueColumnResolver.findColumn(String name)
Column[]	SelectListColumnResolver.getColumns()
Column[]	TableValueConstructor.TableValueColumnResolver.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.
private int	Select.addExpandedColumn(TableFilter filter, int index, HashMap<Column, ExpressionColumn> except, String schema, String alias, Column c)
Value	SelectListColumnResolver.getValue(Column column)
Value	TableValueConstructor.TableValueColumnResolver.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)
Expression	TableValueConstructor.TableValueColumnResolver.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)

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

Modifier and Type	Method	Description
private int	Select.addExpandedColumn(TableFilter filter, int index, HashMap<Column, ExpressionColumn> except, String schema, String alias, Column c)
private int	Select.expandColumnList(TableFilter filter, int index, boolean forAlias, HashMap<Column, ExpressionColumn> except)

Uses of Column in org.h2.constraint

Fields in org.h2.constraint declared as Column

Modifier and Type	Field	Description
private final Column	DomainColumnResolver.column

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
private boolean	ConstraintDomain.CheckExistingData.checkColumn(Domain domain, Column targetColumn)
Value	DomainColumnResolver.getValue(Column col)

Uses of Column in org.h2.expression

Fields in org.h2.expression declared as Column

Modifier and Type	Field	Description
private Column	ExpressionColumn.column
private Column	Parameter.column

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
(package private) void	ExpressionVisitor.addColumn1(Column column)	Add a new column to the set of columns.
(package private) void	ExpressionVisitor.addColumn2(Column column)	Add a new column to the set of columns.
private void	ExpressionColumn.mapColumn(ColumnResolver resolver, Column col, int level)
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

Fields in org.h2.expression.function.table declared as Column

Modifier and Type	Field	Description
private Column[]	ArrayTableFunction.columns

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
private final Column	IndexCondition.column
protected Column[]	Index.columns	Table columns used in this index.
private Column	IndexCursor.inColumn

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
private void	LinkedIndex.addParameter(StringBuilder builder, Column col)
private boolean	IndexCursor.canUseIndexFor(Column column)
private boolean	IndexCursor.canUseIndexForIn(Column column)
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.jdbc.meta

Methods in org.h2.jdbc.meta with parameters of type Column

Modifier and Type	Method	Description
private void	DatabaseMetaLocal.addPrivilege(SimpleResult result, Value catalogValue, Value schemaValue, Value tableValue, Value granteeValue, String right, boolean isAdmin, CompareLike columnLike, Column[] columns)
private void	DatabaseMetaLocal.addPrivileges(SimpleResult result, Value catalogValue, String schemaName, String tableName, DbObject grantee, int rightMask, CompareLike columnLike, Column[] columns)
private void	DatabaseMetaLocal.getPseudoColumnsAdd(SimpleResult result, Value catalogValue, Value schemaValue, Value tableName, CompareLike columnLike, Column c)

Uses of Column in org.h2.mode

Fields in org.h2.mode declared as Column

Modifier and Type	Field	Description
private final Column	OnDuplicateKeyValues.column

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

Modifier and Type	Method	Description
private void	PgCatalogTable.addAttribute(SessionLocal session, ArrayList<Row> rows, int id, int relId, Table table, Column column, int ordinal)

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

Fields in org.h2.mvstore.db declared as Column

Modifier and Type	Field	Description
private Column	MVTable.rowIdColumn

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.
private Column[]	GeneratedColumnResolver.columns
protected Column[]	Table.columns	The columns of this table.
private Column[]	TableView.columnTemplates

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

Modifier and Type	Field	Description
private HashMap<String,Column>	GeneratedColumnResolver.columnMap
private final HashMap<String,Column>	Table.columnMap
private LinkedHashMap<Column,Column>	TableFilter.commonJoinColumns	Map of common join columns, used for NATURAL joins and USING clause of other joins.
private LinkedHashMap<Column,Column>	TableFilter.commonJoinColumns	Map of common join columns, used for NATURAL joins and USING clause of other joins.
private ArrayList<Column>	TableFilter.commonJoinColumnsToExclude
private LinkedHashMap<Column,String>	TableFilter.derivedColumnMap	Map of derived column names.

Methods in org.h2.table that return Column

Modifier and Type	Method	Description
(package private) final Column	MetaTable.column(String name)	Creates a column with the specified name and character string data type.
protected final Column	MetaTable.column(String name, TypeInfo type)	Creates a column with the specified name and data type.
private Column[]	GeneratedColumnResolver.createColumns()
Column	ColumnResolver.findColumn(String name)	Get the column with the specified name.
Column	GeneratedColumnResolver.findColumn(String 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[]	GeneratedColumnResolver.getColumns()
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	GeneratedColumnResolver.getRowIdColumn()
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.
private void	InformationSchemaTable.addConstraintColumnUsage(SessionLocal session, ArrayList<Row> rows, String catalog, Constraint constraint, Column column)
private void	InformationSchemaTableLegacy.addConstraintColumnUsage(SessionLocal session, ArrayList<Row> rows, String catalog, Constraint constraint, Column column)
private void	InformationSchemaTable.columns(SessionLocal session, ArrayList<Row> rows, String catalog, String mainSchemaName, String collation, Table table, String tableName, Column c, int ordinalPosition)
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)
private Value	TableFilter.getDelegatedValue(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	GeneratedColumnResolver.getValue(Column column)
Value	TableFilter.getValue(Column column)
private void	TableView.init(String querySQL, ArrayList<Parameter> params, Column[] columnTemplates, SessionLocal session, boolean allowRecursive, boolean literalsChecked, boolean isTableExpression)
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
private void	TableLink.addIndex(List<Column> list, int uniqueColumnCount, IndexType indexType)
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.
private void	TableLink.readIndexes(DatabaseMetaData meta, HashMap<String,Column> columnMap)
private void	TableLink.readIndexes(ResultSet rs, HashMap<String,Column> columnMap, String pkName)
private String	TableLink.readPrimaryKey(ResultSet rs, HashMap<String,Column> columnMap)

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)