Uses of Class
org.h2.table.Table
Packages that use Table
Package
Description
Contains interfaces for user-defined extensions, such as triggers and user-defined aggregate functions.
This package contains the parser and the base classes for prepared SQL statements.
Contains DDL (data definition language) and related SQL statements.
Contains DML (data manipulation language) and related SQL statements.
Contains queries.
Database constraints such as check constraints, unique constraints, and referential constraints.
Contains high level classes of the database and classes that don't fit in another sub-package.
Expressions include mathematical operations, simple values, and others.
Various table index implementations, as well as cursors to navigate in an index.
Implementation of the JDBC database metadata API (package java.sql).
Utility classes for compatibility with other database, for example MySQL.
Helper classes to use the MVStore in the H2 database.
Implementation of row and internal result sets.
Schema implementation and objects that are stored in a schema (for example, sequences and constants).
Classes related to a table and table meta data.
-
Uses of Table in org.h2.api
Methods in org.h2.api that return TableModifier and TypeMethodDescriptionTableEngine.createTable
(CreateTableData data) Create new table. -
Uses of Table in org.h2.command
Methods in org.h2.command that return TableModifier and TypeMethodDescriptionParser.parseTableName
(String sql) Parse a SQL code snippet that represents a table name.private Table
Parser.readDataChangeDeltaTable
(String resultOptionName, int backupIndex) private Table
Parser.readTableOrView()
private Table
Parser.readTableOrView
(String tableName) private Table
Parser.tableIfTableExists
(Schema schema, String tableName, boolean ifTableExists) Methods in org.h2.command with parameters of type TableModifier and TypeMethodDescriptionprivate TableFilter
Parser.buildTableFilter
(Table table, String alias, ArrayList<String> derivedColumnNames, IndexHints indexHints) private Column
Parser.parseColumn
(Table table) private Column[]
Parser.parseColumnList
(Table table) private IndexHints
Parser.parseIndexHints
(Table table) private void
Parser.parseInsertCompatibility
(Insert command, Table table, Mode mode) private void
Parser.parseInsertSet
(Insert command, Table table, Column[] columns) private Expression
Parser.readOnDuplicateKeyValues
(Table table, Update update) -
Uses of Table in org.h2.command.ddl
Fields in org.h2.command.ddl declared as TableModifier and TypeFieldDescriptionprivate Table
Analyze.table
used in ANALYZE TABLE...private Table
TruncateTable.table
Fields in org.h2.command.ddl with type parameters of type TableMethods in org.h2.command.ddl that return TableModifier and TypeMethodDescriptionprivate Table
AlterTableAlterColumn.cloneTableStructure
(Table table, Column[] columns, Database db, String tempName, ArrayList<Column> newColumns) Methods in org.h2.command.ddl with parameters of type TableModifier and TypeMethodDescriptionprivate void
AlterTableAddConstraint.addConstraintToTable
(Database db, Table table, Constraint constraint) void
Add the specified table to the list of tables.static void
Analyze.analyzeTable
(SessionLocal session, Table table, int sample, boolean manual) Analyze this table.private static boolean
AlterTableAddConstraint.canUseIndex
(Index index, Table table, IndexColumn[] cols, boolean unique) private static void
AlterTableAlterColumn.checkDefaultReferencesTable
(Table table, Expression defaultExpression) private void
AlterTableAlterColumn.checkNoNullValues
(Table table) private void
AlterTableAlterColumn.checkNullable
(Table table) private Table
AlterTableAlterColumn.cloneTableStructure
(Table table, Column[] columns, Database db, String tempName, ArrayList<Column> newColumns) private void
AlterTableAlterColumn.convertIdentityColumn
(Table table, Column c) private void
AlterTableAlterColumn.copyData
(Table table, ArrayList<Sequence> sequences, boolean createConstraints) private Index
AlterTableAddConstraint.createIndex
(Table t, IndexColumn[] cols, boolean unique) private ConstraintUnique
AlterTableAddConstraint.createUniqueConstraint
(Table table, Index index, IndexColumn[] indexColumns, boolean forForeignKey) private static boolean
AlterDomain.forTable
(SessionLocal session, Domain domain, BiPredicate<Domain, Column> columnProcessor, boolean recompileExpressions, Table t) private String
AlterTableAddConstraint.generateConstraintName
(Table table) private static Index
AlterTableAddConstraint.getIndex
(Table t, IndexColumn[] cols, boolean unique) private static ConstraintUnique
AlterTableAddConstraint.getUniqueConstraint
(Table t, IndexColumn[] cols) private void
AlterTableAlterColumn.removeSequence
(Table table, Sequence sequence) void
void
private int
Try to execute the statement.(package private) abstract long
long
long
long
long
long
-
Uses of Table in org.h2.command.dml
Fields in org.h2.command.dml declared as TableModifier and TypeFieldDescriptionprivate Table
Insert.table
private Table
Merge.table
private final Table
SetClauseList.table
Fields in org.h2.command.dml with type parameters of type TableMethods in org.h2.command.dml that return TableModifier and TypeMethodDescriptionabstract Table
DataChangeStatement.getTable()
Return the target table.final Table
FilteredDataChangeStatement.getTable()
Insert.getTable()
Merge.getTable()
MergeUsing.getTable()
Methods in org.h2.command.dml with parameters of type TableModifier and TypeMethodDescription(package private) static void
Update.doUpdate
(Prepared prepared, SessionLocal session, Table table, LocalResult rows) private boolean
ScriptCommand.excludeTable
(Table table) private int
ScriptCommand.generateInsertValues
(int count, Table table) (package private) boolean
SetClauseList.prepareUpdate
(Table table, SessionLocal session, ResultTarget deltaChangeCollector, DataChangeDeltaTable.ResultOption deltaChangeCollectionMode, LocalResult rows, Row oldRow, boolean updateToCurrentValuesReturnsZero) void
void
Method parameters in org.h2.command.dml with type arguments of type TableConstructors in org.h2.command.dml with parameters of type Table -
Uses of Table in org.h2.command.query
Fields in org.h2.command.query with type parameters of type TableMethods in org.h2.command.query that return TableModifier and TypeMethodDescriptionQuery.toTable
(String alias, Column[] columnTemplates, ArrayList<Parameter> parameters, boolean forCreateView, Query topQuery) Converts this query to a table or a view.TableValueConstructor.toTable
(String alias, Column[] columnTemplates, ArrayList<Parameter> parameters, boolean forCreateView, Query topQuery) Methods in org.h2.command.query that return types with arguments of type TableModifier and TypeMethodDescriptionQuery.getTables()
Get all tables that are involved in this query.Select.getTables()
SelectUnion.getTables()
TableValueConstructor.getTables()
Methods in org.h2.command.query with parameters of type Table -
Uses of Table in org.h2.constraint
Fields in org.h2.constraint declared as TableModifier and TypeFieldDescriptionprivate Table
ConstraintReferential.refTable
protected Table
Constraint.table
The table for which this constraint is defined.Methods in org.h2.constraint that return TableModifier and TypeMethodDescriptionConstraint.getRefTable()
ConstraintReferential.getRefTable()
Constraint.getTable()
Methods in org.h2.constraint with parameters of type TableModifier and TypeMethodDescriptionabstract void
Constraint.checkRow
(SessionLocal session, Table t, Row oldRow, Row newRow) Check if this row fulfils the constraint.void
ConstraintCheck.checkRow
(SessionLocal session, Table t, Row oldRow, Row newRow) void
ConstraintDomain.checkRow
(SessionLocal session, Table t, Row oldRow, Row newRow) void
ConstraintReferential.checkRow
(SessionLocal session, Table t, Row oldRow, Row newRow) void
ConstraintUnique.checkRow
(SessionLocal session, Table t, Row oldRow, Row newRow) ConstraintCheck.getCreateSQLForCopy
(Table forTable, String quotedName) ConstraintDomain.getCreateSQLForCopy
(Table forTable, String quotedName) ConstraintReferential.getCreateSQLForCopy
(Table forTable, String quotedName) Create the SQL statement of this object so a copy of the table can be made.ConstraintReferential.getCreateSQLForCopy
(Table forTable, Table forRefTable, String quotedName, boolean internalIndex) Create the SQL statement of this object so a copy of the table can be made.ConstraintUnique.getCreateSQLForCopy
(Table forTable, String quotedName) private String
ConstraintUnique.getCreateSQLForCopy
(Table forTable, String quotedName, boolean internalIndex) Constraint.getReferencedColumns
(Table table) Get all referenced columns.ConstraintCheck.getReferencedColumns
(Table table) ConstraintDomain.getReferencedColumns
(Table table) ConstraintReferential.getReferencedColumns
(Table table) ConstraintUnique.getReferencedColumns
(Table table) void
ConstraintReferential.setRefTable
(Table refTable) Constructors in org.h2.constraint with parameters of type TableModifierConstructorDescription(package private)
Constraint
(Schema schema, int id, String name, Table table) ConstraintCheck
(Schema schema, int id, String name, Table table) ConstraintReferential
(Schema schema, int id, String name, Table table) ConstraintUnique
(Schema schema, int id, String name, Table table, boolean primaryKey) -
Uses of Table in org.h2.engine
Fields in org.h2.engine declared as TableModifier and TypeFieldDescriptionprivate final Table
Database.meta
private Table
SessionLocal.waitForLock
Fields in org.h2.engine with type parameters of type TableModifier and TypeFieldDescriptionSessionLocal.localTempTables
SessionLocal.locks
SessionLocal.tablesToAnalyze
Tables marked for ANALYZE after the current transaction is committed.Methods in org.h2.engine that return TableModifier and TypeMethodDescriptionSessionLocal.findLocalTempTable
(String name) Get the local temporary table if one exists with that name, or null if not.Database.getDependentTable
(SchemaObject obj, Table except) Get the first table that depends on this object.Database.getFirstUserTable()
Get the first user defined table, excluding the LOB_BLOCKS table that the Recover tool creates.SessionLocal.getWaitForLock()
Methods in org.h2.engine that return types with arguments of type TableModifier and TypeMethodDescriptionDatabase.getAllTablesAndViews()
Get all tables and views.SessionLocal.getLocalTempTables()
SessionLocal.getLocks()
Methods in org.h2.engine with parameters of type TableModifier and TypeMethodDescriptionvoid
SessionLocal.addLocalTempTable
(Table table) Add a local temporary table to this session.void
User.checkTableRight
(Table table, int rightMask) Checks that this user has the given rights for the specified table.Comment.getCreateSQLForCopy
(Table table, String quotedName) abstract String
DbObject.getCreateSQLForCopy
(Table table, String quotedName) Build a SQL statement to re-create the object, or to create a copy of the object with a different name or referencing a different tableRight.getCreateSQLForCopy
(Table table, String quotedName) Role.getCreateSQLForCopy
(Table table, String quotedName) Setting.getCreateSQLForCopy
(Table table, String quotedName) User.getCreateSQLForCopy
(Table table, String quotedName) Database.getDependentTable
(SchemaObject obj, Table except) Get the first table that depends on this object.boolean
User.hasTableRight
(Table table, int rightMask) See if this user has the given rights for this database object.(package private) final boolean
RightOwner.isTableRightGrantedRecursive
(Table table, int rightMask) Checks if a right is already granted to this object or to objects that were granted to this object.void
SessionLocal.markTableForAnalyze
(Table table) Mark that the given table needs to be analyzed on commit.void
SessionLocal.registerTableAsLocked
(Table table) Register table as locked within current transaction.void
SessionLocal.registerTableAsUpdated
(Table table) Register table as updated within current transaction.void
SessionLocal.removeLocalTempTable
(Table table) Drop and remove the given local temporary table from this session.void
SessionLocal.setWaitForLock
(Table waitForLock, Thread waitForLockThread) Set the table this session is waiting for, and the thread that is waiting.(package private) void
Unlock just this table. -
Uses of Table in org.h2.expression
Fields in org.h2.expression declared as TableMethods in org.h2.expression that return TableMethods in org.h2.expression with parameters of type TableModifier and TypeMethodDescriptionstatic ExpressionVisitor
ExpressionVisitor.getColumnsVisitor
(HashSet<Column> columns, Table table) Create a new visitor to get all referenced columns.static ExpressionVisitor
ExpressionVisitor.getOptimizableVisitor
(Table table) Create a new visitor to check if all aggregates are for the given table.Constructors in org.h2.expression with parameters of type TableModifierConstructorDescriptionprivate
ExpressionVisitor
(int type, int queryLevel, HashSet<?> set, AllColumnsForPlan columns1, Table table, ColumnResolver resolver, long[] maxDataModificationId) -
Uses of Table in org.h2.index
Fields in org.h2.index declared as TableModifier and TypeFieldDescriptionprotected final Table
Index.table
The table.private Table
IndexCursor.table
private final Table
ViewCursor.table
Methods in org.h2.index that return TableMethods in org.h2.index with parameters of type TableModifier and TypeMethodDescriptionIndex.getCreateSQLForCopy
(Table targetTable, String quotedName) Constructors in org.h2.index with parameters of type TableModifierConstructorDescriptionprotected
Index
(Table newTable, int id, String name, IndexColumn[] newIndexColumns, int uniqueColumnCount, IndexType newIndexType) Initialize the index. -
Uses of Table in org.h2.jdbc.meta
Methods in org.h2.jdbc.meta with parameters of type TableModifier and TypeMethodDescriptionprivate void
DatabaseMetaLocal.addCrossReferenceResult
(SimpleResult result, Value catalog, String pkSchema, Table pkTable, String fkSchema, Table fkTable, ConstraintReferential fk) private void
DatabaseMetaLocal.getColumnsAdd
(SimpleResult result, Value catalogValue, Value schemaValue, Value tableName, Table t, CompareLike columnLike) private void
DatabaseMetaLocal.getIndexInfo
(Value catalogValue, Value schemaValue, Table table, boolean unique, boolean approximate, SimpleResult result, Database db) private void
DatabaseMetaLocal.getPseudoColumnsAdd
(SimpleResult result, Value catalogValue, Value schemaValue, Value tableName, Table t, CompareLike columnLike) private void
DatabaseMetaLocal.getTablesAdd
(SimpleResult result, Value catalogValue, Value schemaValue, Value tableName, Table t, boolean synonym, HashSet<String> typesSet) -
Uses of Table in org.h2.mode
Subclasses of Table in org.h2.modeModifier and TypeClassDescriptionfinal class
This class is responsible to build the pg_catalog tables.Fields in org.h2.mode with type parameters of type TableMethods in org.h2.mode that return types with arguments of type TableModifier and TypeMethodDescriptionPgCatalogSchema.fillMap()
PgCatalogSchema.getMap
(SessionLocal session) Methods in org.h2.mode with parameters of type TableModifier and TypeMethodDescriptionprivate void
PgCatalogTable.addAttribute
(SessionLocal session, ArrayList<Row> rows, int id, int relId, Table table, Column column, int ordinal) private void
PgCatalogTable.pgAttribute
(SessionLocal session, ArrayList<Row> rows, Table table) private void
PgCatalogTable.pgClass
(SessionLocal session, ArrayList<Row> rows, Table table) -
Uses of Table in org.h2.mvstore.db
Subclasses of Table in org.h2.mvstore.dbConstructors in org.h2.mvstore.db with parameters of type TableModifierConstructorDescriptionprotected
MVIndex
(Table newTable, int id, String name, IndexColumn[] newIndexColumns, int uniqueColumnCount, IndexType newIndexType) -
Uses of Table in org.h2.result
Methods in org.h2.result with parameters of type TableModifier and TypeMethodDescriptionstatic LocalResult
LocalResult.forTable
(SessionLocal session, Table table) Constructs a new local result object for the specified table. -
Uses of Table in org.h2.schema
Fields in org.h2.schema declared as TableFields in org.h2.schema with type parameters of type TableModifier and TypeFieldDescriptionInformationSchema.newTables
InformationSchema.oldTables
private final ConcurrentHashMap
<String, Table> Schema.tablesAndViews
Methods in org.h2.schema that return TableModifier and TypeMethodDescriptionSchema.createTable
(CreateTableData data) Add a table to the schema.MetaSchema.findTableOrView
(SessionLocal session, String name) Schema.findTableOrView
(SessionLocal session, String name) Try to find a table or view with this name.TriggerObject.getTable()
Get the table of this trigger.MetaSchema.getTableOrView
(SessionLocal session, String name) Schema.getTableOrView
(SessionLocal session, String name) Get the table or view with the given name.MetaSchema.getTableOrViewByName
(SessionLocal session, String name) Schema.getTableOrViewByName
(SessionLocal session, String name) Get the table with the given name, if any.Schema.resolveTableOrView
(SessionLocal session, String name) Try to find a table or view with this name.Methods in org.h2.schema that return types with arguments of type TableModifier and TypeMethodDescriptionInformationSchema.fillMap
(boolean old) MetaSchema.getAllTablesAndViews
(SessionLocal session) Schema.getAllTablesAndViews
(SessionLocal session) Get all tables and views.InformationSchema.getMap
(SessionLocal session) MetaSchema.getMap
(SessionLocal session) Returns map of tables in this schema.Methods in org.h2.schema with parameters of type TableModifier and TypeMethodDescriptionprivate static JdbcResultSet
TriggerObject.createResultSet
(JdbcConnection conn, Table table, Row row, boolean updatable) boolean
TriggerObject.fireRow
(SessionLocal session, Table table, Row oldRow, Row newRow, boolean beforeAction, boolean rollback) Call the fire method of the user-defined trigger class if required.Constant.getCreateSQLForCopy
(Table table, String quotedName) Domain.getCreateSQLForCopy
(Table table, String quotedName) Schema.getCreateSQLForCopy
(Table table, String quotedName) Sequence.getCreateSQLForCopy
(Table table, String quotedName) TriggerObject.getCreateSQLForCopy
(Table targetTable, String quotedName) final String
UserDefinedFunction.getCreateSQLForCopy
(Table table, String quotedName) Schema.getUniqueConstraintName
(SessionLocal session, Table table) Create a unique constraint name.Schema.getUniqueIndexName
(SessionLocal session, Table table, String prefix) Create a unique index name.Constructors in org.h2.schema with parameters of type Table -
Uses of Table in org.h2.table
Subclasses of Table in org.h2.tableModifier and TypeClassDescriptionclass
A data change delta table.class
The DUAL table for selects without a FROM clause.class
A table backed by a system or user-defined function that returns a result set.final class
This class is responsible to build the INFORMATION_SCHEMA tables.final class
This class is responsible to build the legacy variant of INFORMATION_SCHEMA tables.class
This class is responsible to build the database meta data pseudo tables.class
The table SYSTEM_RANGE is a virtual table that generates incrementing numbers with a given start end point.class
The base class of a regular table, or a user defined table.class
A linked table contains connection information for a table accessible by JDBC.class
A table for table value constructor.class
A view is a virtual table that is defined by a query.class
A base class for virtual tables that construct all their content at once.class
A base class for virtual tables.Fields in org.h2.table declared as TableModifier and TypeFieldDescriptionprivate Table
TableSynonym.synonymFor
The table the synonym is created for.private Table
Column.table
private final Table
GeneratedColumnResolver.table
private final Table
TableFilter.table
Fields in org.h2.table with type parameters of type TableMethods in org.h2.table that return TableModifier and TypeMethodDescriptionstatic Table
TableView.createShadowTableForRecursiveTableExpression
(boolean isTemporary, SessionLocal targetSession, String cteViewName, Schema schema, List<Column> columns, Database db) Create a table for a recursive query.TableSynonym.getSynonymFor()
Column.getTable()
TableFilter.getTable()
Methods in org.h2.table that return types with arguments of type TableModifier and TypeMethodDescriptionInformationSchemaTableLegacy.getAllTables
(SessionLocal session) Get all tables of this database, including local temporary tables for the session.TableView.getTables()
InformationSchemaTableLegacy.getTablesByName
(SessionLocal session, String tableName) Methods in org.h2.table with parameters of type TableModifier and TypeMethodDescriptionprivate void
InformationSchemaTable.addPrivilege
(SessionLocal session, ArrayList<Row> rows, DbObject grantee, String catalog, Table table, String column, String right) private void
InformationSchemaTableLegacy.addPrivilege
(SessionLocal session, ArrayList<Row> rows, DbObject grantee, String catalog, Table table, String column, String right) private void
InformationSchemaTable.addPrivileges
(SessionLocal session, ArrayList<Row> rows, DbObject grantee, String catalog, Table table, String column, int rightMask) private void
InformationSchemaTableLegacy.addPrivileges
(SessionLocal session, ArrayList<Row> rows, DbObject grantee, String catalog, Table table, String column, int rightMask) static void
DataChangeDeltaTable.collectInsertedFinalRow
(SessionLocal session, Table table, ResultTarget deltaChangeCollector, DataChangeDeltaTable.ResultOption deltaChangeCollectionMode, Row newRow) Collects final row for INSERT operations.private void
InformationSchemaTable.columns
(SessionLocal session, ArrayList<Row> rows, String catalog, String mainSchemaName, String collation, Table table, String tableName) private void
InformationSchemaTable.columns
(SessionLocal session, ArrayList<Row> rows, String catalog, String mainSchemaName, String collation, Table table, String tableName, Column c, int ordinalPosition) static void
TableView.destroyShadowTableForRecursiveExpression
(boolean isTemporary, SessionLocal targetSession, Table recursiveTable) Remove a table for a recursive query.private void
InformationSchemaTable.elementTypesFieldsForTable
(SessionLocal session, ArrayList<Row> rows, String catalog, int type, String mainSchemaName, String collation, String schemaName, Table table) Table.getCreateSQLForCopy
(Table table, String quotedName) TableSynonym.getCreateSQLForCopy
(Table table, String quotedName) TableView.getCreateSQLForCopy
(Table table, String quotedName) protected final boolean
MetaTable.hideTable
(Table table, SessionLocal session) Check whether to hide the table.private void
InformationSchemaTable.indexColumns
(SessionLocal session, ArrayList<Row> rows, String catalog, Table table, String tableName, Index index) private void
InformationSchemaTable.indexes
(SessionLocal session, ArrayList<Row> rows, String catalog, boolean columns, Table table, String tableName) private void
InformationSchemaTable.indexes
(SessionLocal session, ArrayList<Row> rows, String catalog, Table table, String tableName, Index index) private void
InformationSchemaTable.keyColumnUsage
(SessionLocal session, ArrayList<Row> rows, String catalog, Constraint constraint, Constraint.Type constraintType, IndexColumn[] indexColumns, Table table, String tableName) static void
IndexColumn.mapColumns
(IndexColumn[] indexColumns, Table table) Map the columns using the column names and the specified table.void
Set the table and column id.private void
InformationSchemaTable.tableConstraints
(SessionLocal session, ArrayList<Row> rows, String catalog, Constraint constraint, Constraint.Type constraintType, Table table, String tableName) private void
InformationSchemaTable.tables
(SessionLocal session, ArrayList<Row> rows, String catalog, Table table, String tableName) private void
InformationSchemaTable.triggers
(SessionLocal session, ArrayList<Row> rows, String catalog, TriggerObject trigger, String eventManipulation, Table table, String tableName) private void
InformationSchemaTable.views
(SessionLocal session, ArrayList<Row> rows, String catalog, Table table, String tableName) Constructors in org.h2.table with parameters of type TableModifierConstructorDescription(package private)
GeneratedColumnResolver
(Table table) Column resolver for generated columns.TableFilter
(SessionLocal session, Table table, String alias, boolean rightsChecked, Select select, int orderInFrom, IndexHints indexHints) Create a new table filter object.