| Class and Description |
|---|
| TColumnDefinition
Define the characteristics of the column.
|
| TColumnDefinitionList |
| TColumnWithSortOrder |
| TConstant
SQL constant (sometimes called a literal) specifies a value.
|
| TCTE
A common table expression permits defining a result table with a table-name that can be specified as a table name in any FROM clause of the fullselect that follows.
|
| TCTEList
Collections of
TCTE. |
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TFromClause |
| TFromTable
Represents table source in from clause of select/delete statement, and update table clause of update statement.
|
| TFunctionCall
Represents the database function, all functions are represented by this class no matter what's type of the function.
|
| TJoin
Deprecated.
As of v2.7.4.0, Please use
TJoinExpr instead.
A list of join TCustomSqlStatement.joins represents table sources in following clauses of SQL statement:
Each table source in from clause was treated as a join which is type of TJoin.
The reason for this design is that we can treat all table sources in from clause in a uniform way. |
| TJoinExpr
Represents a JOIN expression in SQL statements.
|
| TJoinList |
| TNodeFactory |
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList
List of TObjectName
|
| TOutputClause |
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| TPTNodeList |
| TResultColumn
This class represents select_list item in select statement, lets you specify the columns you want to retrieve from the table.
|
| TResultColumnList |
| TReturningClause |
| TTable
Represents various kinds of table source in from clause.
|
| TTableList |
| TTopClause
Indicates that only a specified first set or percent of rows will be returned from the query result set.
|
| TWhereClause |
| Visitable |
| Class and Description |
|---|
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| Class and Description |
|---|
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| Class and Description |
|---|
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| Class and Description |
|---|
| TColumnDefinition
Define the characteristics of the column.
|
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TFunctionCall
Represents the database function, all functions are represented by this class no matter what's type of the function.
|
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TTable
Represents various kinds of table source in from clause.
|
| Class and Description |
|---|
| TAliasClause
The column/table alias.
|
| TCaseExpression
CASE expressions let you use IF ...
|
| TConstant
SQL constant (sometimes called a literal) specifies a value.
|
| TCTE
A common table expression permits defining a result table with a table-name that can be specified as a table name in any FROM clause of the fullselect that follows.
|
| TDeclareVariable
SQL Server declare variable
|
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TFunctionCall
Represents the database function, all functions are represented by this class no matter what's type of the function.
|
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList
List of TObjectName
|
| TParameterDeclaration
Parameters in create procedure/function statements.
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TPivotClause
use the PIVOT and UNPIVOT relational operators to change a table-valued expression into another table.
|
| TResultColumn
This class represents select_list item in select statement, lets you specify the columns you want to retrieve from the table.
|
| TResultColumnList |
| TTable
Represents various kinds of table source in from clause.
|
| TTypeName
This class represents SQL Datatype.
|
| TWhenClauseItemList
List of
TWhenClauseItem |
| Class and Description |
|---|
| TFunctionCall
Represents the database function, all functions are represented by this class no matter what's type of the function.
|
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| Class and Description |
|---|
| EAlterTypeOption |
| ECreateFunctionOptionType |
| EForXMLMode |
| EHiveInsertType |
| ENodeStatus |
| ENodeType
Type of parse tree node
|
| IExpressionVisitor
TExpression
|
| TAliasClause
The column/table alias.
|
| TAlterTableOption
Type of alter table option,
TAlterTableOption.getOptionType() returns the type of various option:
|
| TAlterTableOptionList
alter table options
|
| TAlterTypeOption |
| TAnalyticFunction
Deprecated.
As of v1.8.6.3, replaced by
TWindowDef
Window/analytic clause of Window (or analytic) functions.
partitioning ::= PARTITION BY value[, value...], call method
ordering ::= ORDER [SIBLINGS] BY rule[, rule...], call method |
| TArrayAccess
array access of plsql.
|
| TAttributeOption
Postgresql attribute_option = value
#Todo: this class needs to be replaced by
TNameValuePair later |
| TAttributeOption.EValueType |
| TAttributeOrMethod |
| TAuthorizationClause |
| TAuthorizationClause.EAuthorizationType |
| TAutomaticProperty
Automatic Initialization and Updating for TIMESTAMP in MySQL
|
| TBaseTablePartition
Base partition of all table partitions, such as range_partitions, list_partitions,
hash_partitions,composite_range_partitions and etc
|
| TBindArgument
Bind argument in using_clause of plsql execute_immediate_statement
|
| TBindArgumentList
List of
TBindArgument |
| TBlockSqlNode
TBlockSqlNode represents a block in a stored procedure.
|
| TCallSpec
Call specification in PLSQL when define a function
|
| TCaseExpression
CASE expressions let you use IF ...
|
| TCaseJoinClause
SAP hana case join clause.
|
| TCaseJoinItem
SAP hana case join when item.
|
| TCharacterDatatypeProperty
property of character data type, such as character set name, case specific.
|
| TClusterBy |
| TColumnAttribute |
| TColumnAttributes |
| TColumnDefinition
Define the characteristics of the column.
|
| TColumnDefinitionList |
| TColumnGeneratedClause |
| TColumnReference
TColumnReference represents column, variable, function/procedure parameter
|
| TColumnWithSortOrder |
| TCompositeRangePartitions |
| TCompoundDmlTriggerClause
Use this clause to define a compound trigger on a DML event.
|
| TCompoundSqlNode
DB2 procedure compound statement
|
| TComputeClause
SQL Server compute clause, including a list of compute clause item which is in syntax:
COMPUTE [compute_expr_list] [BY by_expr_list]
|
| TComputeClauseItem
SQL Server compute clause item
|
| TComputeClauseItemList
Deprecated.
As of v1.8.7.2
|
| TComputeExpr |
| TConnectByClause |
| TConstant
SQL constant (sometimes called a literal) specifies a value.
|
| TConstantList |
| TConstraint
Use a constraint to define an integrity constraint, a rule that restricts the values in a database.
|
| TConstraintList
List of
TConstraint. |
| TContainsTable |
| TCreateFunctionOption |
| TCreateSchemaSqlNode.ESchemaMode |
| TCreateTableOption |
| TCTE
A common table expression permits defining a result table with a table-name that can be specified as a table name in any FROM clause of the fullselect that follows.
|
| TCTEList
Collections of
TCTE. |
| TDatabaseEventItem |
| TDataChangeTable
DB2 data change table
|
| TDatatypeAttribute
datatype attributes supported in various databases.
|
| TDatetimeExpression |
| TDdlEventItem |
| TDeclareVariable
SQL Server declare variable
|
| TDeclareVariableList
List of declare variable
|
| TDistributeBy |
| TDmlEventClause
The DML_event_clause lets you specify one of three DML statements that can cause the trigger to fire.
|
| TDmlEventItem
Create trigger dml event: delete, insert, update [of columns]
|
| TDmlSelectItem |
| TDropIndexItem |
| TDropIndexItemList |
| TDummy |
| TDummyList |
| TElseIfSqlNode |
| TElseIfSqlNodeList |
| TExceptionClause
Including a list of
TExceptionHandler that process raised exceptions. |
| TExceptionHandler
An exception handler processes a raised exception.
|
| TExceptionHandlerList |
| TExceptReplaceClause |
| TExecParameter
Parameter of execute statement in SQL Server,teradata
|
| TExecParameterList |
| TExecuteSqlNode |
| TExplicitDataTypeConversion |
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TExpressionCallTarget
SQL Server value() Method performs an XQuery against the XML and returns a value of SQL type.
|
| TExpressionList |
| TFetchFirstClause
DB2 fetch first clause.
|
| TFlashback |
| TForUpdate
The FOR UPDATE clause lets you lock the selected rows so that other users cannot lock
or update the rows until you end your transaction.
|
| TForUpdate.EForUpdateType |
| TFrameExclusionClause |
| TFromClause |
| TFromTable
Represents table source in from clause of select/delete statement, and update table clause of update statement.
|
| TFromTableList |
| TFunctionCall
Represents the database function, all functions are represented by this class no matter what's type of the function.
|
| TFunctionHeader
A structure includes function name and arguments
|
| TGrantSqlNode |
| TGroupBy
This class represents group by clause and having clause.
|
| TGroupByItem |
| TGroupByItemList |
| TGroupingExpressionItem
Deprecated.
As of v1.4.3.3, replaced by
TExpression |
| TGroupingExpressionItemList
Deprecated.
As of v1.4.3.3, replaced by
TExpressionList |
| TGroupingSet
GROUPING SETS are a further extension of the GROUP BY clause that let you specify multiple groupings of data.
|
| TGroupingSetItem
Gruping set item that used in TGroupingSet
Content of this item can be a TRollupCube instance or a TGroupingExpressionItem instance
|
| TGroupingSetItemList
Grouping set item list in TGroupingSet.
|
| THandlerForCondition
Teradata handler for clause
|
| THandlerForCondition.EHandlerForType |
| THashPartitions |
| THavingClause |
| THierarchical
Oracle hierarchical_query_clause lets you select rows in a hierarchical order.
|
| THintClause
Hint clause in Hana
|
| TIdentityClause
Column identity clause.
|
| TIndexColName
Deprecated.
as V1.8.7.2, replaced by
TColumnWithSortOrder |
| TIndices
Postgresql;
|
| TIndirection
Postgresql, redshift
|
| TInExpr
Deprecated.
As of v1.4.3.3, replaced by
TExpression |
| TInformixOuterClause |
| TInsertCondition |
| TInsertIntoValue |
| TInsertSqlNode
Interal used by parser.
|
| TIntervalExpression |
| TIntoClause |
| TIntoTableClause
Informix, into table clause.
|
| TIsolationClause
DB2/Sybase isolation clause
|
| TJoin
Deprecated.
As of v2.7.4.0, Please use
TJoinExpr instead.
A list of join TCustomSqlStatement.joins represents table sources in following clauses of SQL statement:
Each table source in from clause was treated as a join which is type of TJoin.
The reason for this design is that we can treat all table sources in from clause in a uniform way. |
| TJoinExpr
Represents a JOIN expression in SQL statements.
|
| TJoinItem
Deprecated.
As of v2.7.4.0, Please use
TJoinExpr instead.
SQL 1: In above SQL, the whole from clause can be represented by aselect f from t1 left join t2 on t1.f1 = t2.f1 right join t3 on t1.f1 = t3.f1 TJoin class.
And "left join t2 on t1.f1 = t2.f1 right join t3 on t1.f1 = t3.f1" was represented by 2 instance of class These 2 instance can be accessed via One for: "left join t2 on t1.f1 = t2.f1", the other is "right join t3 on t1.f1 = t3.f1". |
| TJoinItemList |
| TJoinList |
| TJsonObjectKeyValue |
| TJsonTable
This class is used to represent a JSON_TABLE function in Oracle and OpenJson function in SQL Server.
|
| TKeepDenseRankClause
Oracle keep dense rank clause used in analytic function.
|
| TKeyAction |
| TKeyPartitions |
| TKeyReference |
| TKeyValueSqlNode |
| TLateralView |
| TLimitClause |
| TListPartitions |
| TListValuesClause
list values clause in hash partitions
|
| TLockingClause
Postgresql locking clause
|
| TLockingClauseList |
| TMergeActionClause |
| TMergeActionClause.EMergeActionType |
| TMergeDeleteClause |
| TMergeDoNothingClause |
| TMergeInsertClause
insert clause in merge statement.
|
| TMergeSqlNode |
| TMergeUpdateClause
update clause in merge statement.
|
| TMergeWhenClause
when [not] matched clause in merge statement.
|
| TMultiTarget
Represents a row in value clause of insert statement, or a row in values clause.
|
| TMultiTargetList
Represents one or more rows in the values clause of insert statement, or in the values() clause.
|
| TMySQLCreateTableOption |
| TMySQLIndexStorageType |
| TNameValuePair |
| TNewVariantTypeArgument |
| TNewVariantTypeArgumentList |
| TNodeWithAliasClause |
| TNodeWithLabel |
| TNonDmlTriggerClause
Use this clause to define a single trigger on a DDL or database event.
|
| TObjectAccess
An object access expression specifies attribute reference and method invocation.
|
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList
List of TObjectName
|
| TObjectReference |
| TOffsetClause
PostgreSQL offset clause in select limit
Oracle offset clause in select |
| TOpenDatasource |
| TOpenQuery |
| TOpenRowSet |
| TOpenXML |
| TOptimizeForClause
DB2 Optimize for clause
|
| TOrderBy
List of order by item which is type of
TOrderByItem. |
| TOrderByItem
Item in order by clause.
|
| TOrderByItemList |
| TOutputClause |
| TOutputFormatPhrase
Deprecated.
As of v1.4.9.8, use TExplicitDataTypeConversion instead
teradata output format phrase
|
| TOutputFormatPhraseList
Deprecated.
As of v1.4.9.8, use TExplicitDataTypeConversion with instead
|
| TParameterDeclaration
Parameters in create procedure/function statements.
|
| TParameterDeclarationList
List of
TParameterDeclaration. |
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeNodeList
List of parse tree node.
|
| TParseTreeVisitor |
| TPartitionByClause
Deprecated.
As of v1.8.6.0, replaced by
TPartitionClause |
| TPartitionClause
used in window function
|
| TPartitionDefinition
Partition definition in syntax like:
|
| TPartitionExtensionClause
Hive, Impala, MySQL, Oracle partition clause in from table
|
| TPathSqlNode
Snowflake path object, usually used in stage reference
|
| TPivotClause
use the PIVOT and UNPIVOT relational operators to change a table-valued expression into another table.
|
| TPivotedTable |
| TPivotInClause |
| TPrecisionScale |
| TPTNodeList |
| TPxGranule |
| TQualifyClause
teradata qualify clause
|
| TQueryHint |
| TRangePartitions |
| TRangeValuesClause
range values clause in range partitions
|
| TRelationExpr
Postgresql Relation expr parse tree node
|
| TReplaceExprAsIdentifier |
| TRestrictionClause
Oracle, DB2 restrict clause in create view statement
|
| TResultColumn
This class represents select_list item in select statement, lets you specify the columns you want to retrieve from the table.
|
| TResultColumnList |
| TReturningClause |
| TReturnSqlNode |
| TRollupCube
The ROLLUP operation in the simple_grouping_clause groups the selected rows based on the values of the first n, n-1, n-2, ...
|
| TSampleClause |
| TSelectDistinct |
| TSelectModifier |
| TSelectSqlNode
Internal used by parser, reprsents raw parse tree node of select statement.
|
| TSequenceOption |
| TSetAssignment |
| TSimpleDmlTriggerClause |
| TSortBy |
| TStageLocation |
| TStageLocation.EStageLocationType |
| TStatementListSqlNode |
| TStatementSqlNode |
| TSubPartitionByClause
Oracle subpartition type of composite_range_partitions
|
| TSubPartitionByClause.ESubPartitionByType |
| TSubscripts |
| TTable
Represents various kinds of table source in from clause.
|
| TTableElement |
| TTableElementList |
| TTableFunction |
| TTableHint
SQL Server table hint:
|
| TTableList |
| TTablePartitionItem
#TODO Need to be merged into
TPartitionDefinition |
| TTablePartitionItem.ETablePartitionItemType |
| TTableProperties
Oracle table properties
|
| TTableReference |
| TTableReferenceList |
| TTableSample |
| TTableSamplePart |
| TTeradataWithClause |
| TTeradataWithClauseItem |
| TTeradataWithClauseItemList |
| TTopClause
Indicates that only a specified first set or percent of rows will be returned from the query result set.
|
| TTriggerAction |
| TTriggerEventClause
One of these 3 event clauses:
dml event clause, ddl event clause, database event clause
subclass:
TDmlEvenClause, TDdlEventClause, TDatabaseEventClause
|
| TTriggerEventItem
Including 3 types:
TDmlEventItem, TDdlEventItem, TDatabaseEventItem
|
| TTriggeringClause
Trigger clause including:
action time: before, after, instead of
event type: insert, delete, update, ddl event, database event,
TDmlEventClause
referencing clause: old, new ,parent
There are 3 types of triggering clause: simple dml, compound dml, non-dml. |
| TTriggerReferencingClause |
| TTriggerReferencingItem |
| TTrimArgument
Argument of trim function.
|
| TTypeAttribute
Attribute definition of an object type(
TPlsqlCreateType) |
| TTypeAttributeList
List of attribute definition (
TTypeAttribute) of an object type. |
| TTypeName
This class represents SQL Datatype.
|
| TTypeNameList |
| TUnnestClause |
| TUnpivotInClause |
| TUnpivotInClauseItem |
| TValueClause
represents values() clause.
|
| TValueRowItem
Deprecated.
As of v2.3.6.9, please use
TMultiTarget instead |
| TValueRowItemList
Deprecated.
As of v2.3.6.9, please use
TMultiTargetList instead |
| TViewAliasClause |
| TViewAliasItem |
| TViewAliasItemList |
| TWhenClauseItem
WhenClause item used in case expr of
TCaseExpression. |
| TWhenClauseItemList
List of
TWhenClauseItem |
| TWhereClause |
| TWindowClause |
| TWindowDef
Represents over clause in analytic function.
|
| TWindowDefinition
Deprecated.
As of v1.8.6.0, replaced by
TWindowDef |
| TWindowFrame |
| TWindowFrameBoundary |
| TWindowPartitioningSpec |
| TWindowSpecification
Deprecated.
As of v1.8.6.0, replaced by
TWindowDef |
| TWithinGroup
Oracle within group clause used in analytic function
|
| TWithTableLock
Openedge with clause in select statement.
|
| TXMLAttributesClause |
| TXMLPassingClause
Created by tako on 2015/1/20.
|
| TXmlTable |
| TXmlTableParameter |
| Visitable |
| Class and Description |
|---|
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TSelectSqlNode
Internal used by parser, reprsents raw parse tree node of select statement.
|
| Visitable |
| Class and Description |
|---|
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TExpressionList |
| TFromTable
Represents table source in from clause of select/delete statement, and update table clause of update statement.
|
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList
List of TObjectName
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| TPTNodeList |
| Visitable |
| Class and Description |
|---|
| TColumnDefinitionList |
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TExpressionList |
| TFunctionCall
Represents the database function, all functions are represented by this class no matter what's type of the function.
|
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList
List of TObjectName
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| TPTNodeList |
| TTable
Represents various kinds of table source in from clause.
|
| Visitable |
| Class and Description |
|---|
| TConstant
SQL constant (sometimes called a literal) specifies a value.
|
| TDummy |
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TFromTable
Represents table source in from clause of select/delete statement, and update table clause of update statement.
|
| TFunctionCall
Represents the database function, all functions are represented by this class no matter what's type of the function.
|
| TJsonObjectKeyValue |
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TOrderBy
List of order by item which is type of
TOrderByItem. |
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| TResultColumnList |
| TTable
Represents various kinds of table source in from clause.
|
| TTableFunction |
| Visitable |
| Class and Description |
|---|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| Visitable |
| Class and Description |
|---|
| TAliasClause
The column/table alias.
|
| TColumnDefinitionList |
| TConstant
SQL constant (sometimes called a literal) specifies a value.
|
| TCTEList
Collections of
TCTE. |
| TExpressionList |
| TFromTable
Represents table source in from clause of select/delete statement, and update table clause of update statement.
|
| TFromTableList |
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList
List of TObjectName
|
| TOrderByItemList |
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| TPartitionExtensionClause
Hive, Impala, MySQL, Oracle partition clause in from table
|
| TPTNodeList |
| TSelectSqlNode
Internal used by parser, reprsents raw parse tree node of select statement.
|
| TStatementSqlNode |
| Visitable |
| Class and Description |
|---|
| TDummy |
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| TPTNodeList |
| Visitable |
| Class and Description |
|---|
| EForXMLMode |
| TColumnDefinition
Define the characteristics of the column.
|
| TColumnDefinitionList |
| TConstant
SQL constant (sometimes called a literal) specifies a value.
|
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TExpressionList |
| TFunctionCall
Represents the database function, all functions are represented by this class no matter what's type of the function.
|
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList
List of TObjectName
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeNodeList
List of parse tree node.
|
| TParseTreeVisitor |
| TPTNodeList |
| TQueryHint |
| TSelectSqlNode
Internal used by parser, reprsents raw parse tree node of select statement.
|
| TTypeName
This class represents SQL Datatype.
|
| Visitable |
| Class and Description |
|---|
| TExpressionList |
| TMySQLIndexStorageType |
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TOrderBy
List of order by item which is type of
TOrderByItem. |
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| Visitable |
| Class and Description |
|---|
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList
List of TObjectName
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| Visitable |
| Class and Description |
|---|
| TConstant
SQL constant (sometimes called a literal) specifies a value.
|
| TDummy |
| TExceptionClause
Including a list of
TExceptionHandler that process raised exceptions. |
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TListValuesClause
list values clause in hash partitions
|
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList
List of TObjectName
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| TPTNodeList |
| TRangeValuesClause
range values clause in range partitions
|
| TStatementListSqlNode |
| Visitable |
| Class and Description |
|---|
| TConstant
SQL constant (sometimes called a literal) specifies a value.
|
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TExpressionList |
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList
List of TObjectName
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| Visitable |
| Class and Description |
|---|
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList
List of TObjectName
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| Visitable |
| Class and Description |
|---|
| TConstant
SQL constant (sometimes called a literal) specifies a value.
|
| TCreateTableOption |
| TDummy |
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TNameValuePair |
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList
List of TObjectName
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| TPathSqlNode
Snowflake path object, usually used in stage reference
|
| TSelectSqlNode
Internal used by parser, reprsents raw parse tree node of select statement.
|
| TStageLocation |
| TStatementSqlNode |
| Visitable |
| Class and Description |
|---|
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList
List of TObjectName
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| Visitable |
| Class and Description |
|---|
| TAliasClause
The column/table alias.
|
| TColumnDefinitionList |
| TConstant
SQL constant (sometimes called a literal) specifies a value.
|
| TConstantList |
| TConstraint
Use a constraint to define an integrity constraint, a rule that restricts the values in a database.
|
| TDatatypeAttribute
datatype attributes supported in various databases.
|
| TDummy |
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TExpressionList |
| TFromTableList |
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList
List of TObjectName
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| TStatementSqlNode |
| TTable
Represents various kinds of table source in from clause.
|
| TTypeName
This class represents SQL Datatype.
|
| TWhereClause |
| Visitable |
| Class and Description |
|---|
| TBaseTablePartition
Base partition of all table partitions, such as range_partitions, list_partitions,
hash_partitions,composite_range_partitions and etc
|
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TGroupBy
This class represents group by clause and having clause.
|
| TNameValuePair |
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList
List of TObjectName
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| TPTNodeList |
| TSelectSqlNode
Internal used by parser, reprsents raw parse tree node of select statement.
|
| Visitable |
| Class and Description |
|---|
| TAlterTableOptionList
alter table options
|
| Class and Description |
|---|
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeNodeList
List of parse tree node.
|
| TTypeName
This class represents SQL Datatype.
|
| Class and Description |
|---|
| TColumnDefinitionList |
| Class and Description |
|---|
| TDeclareVariableList
List of declare variable
|
| Class and Description |
|---|
| TJoinItem
Deprecated.
As of v2.7.4.0, Please use
TJoinExpr instead.
SQL 1: In above SQL, the whole from clause can be represented by aselect f from t1 left join t2 on t1.f1 = t2.f1 right join t3 on t1.f1 = t3.f1 TJoin class.
And "left join t2 on t1.f1 = t2.f1 right join t3 on t1.f1 = t3.f1" was represented by 2 instance of class These 2 instance can be accessed via One for: "left join t2 on t1.f1 = t2.f1", the other is "right join t3 on t1.f1 = t3.f1". |
| Class and Description |
|---|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| Class and Description |
|---|
| TCTE
A common table expression permits defining a result table with a table-name that can be specified as a table name in any FROM clause of the fullselect that follows.
|
| TFromClause |
| TFromTable
Represents table source in from clause of select/delete statement, and update table clause of update statement.
|
| TFunctionCall
Represents the database function, all functions are represented by this class no matter what's type of the function.
|
| TJoinExpr
Represents a JOIN expression in SQL statements.
|
| TMergeInsertClause
insert clause in merge statement.
|
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TParseTreeVisitor |
| TPivotClause
use the PIVOT and UNPIVOT relational operators to change a table-valued expression into another table.
|
| TPivotedTable |
| TResultColumn
This class represents select_list item in select statement, lets you specify the columns you want to retrieve from the table.
|
| TTable
Represents various kinds of table source in from clause.
|
| TTableFunction |
| Class and Description |
|---|
| TAliasClause
The column/table alias.
|
| TAlterTableOption
Type of alter table option,
TAlterTableOption.getOptionType() returns the type of various option:
|
| TCaseExpression
CASE expressions let you use IF ...
|
| TColumnDefinition
Define the characteristics of the column.
|
| TColumnDefinitionList |
| TColumnWithSortOrder |
| TComputeClause
SQL Server compute clause, including a list of compute clause item which is in syntax:
COMPUTE [compute_expr_list] [BY by_expr_list]
|
| TComputeClauseItem
SQL Server compute clause item
|
| TComputeExpr |
| TConnectByClause |
| TConstant
SQL constant (sometimes called a literal) specifies a value.
|
| TConstraint
Use a constraint to define an integrity constraint, a rule that restricts the values in a database.
|
| TConstraintList
List of
TConstraint. |
| TCTE
A common table expression permits defining a result table with a table-name that can be specified as a table name in any FROM clause of the fullselect that follows.
|
| TDdlEventItem |
| TDeclareVariable
SQL Server declare variable
|
| TDeclareVariableList
List of declare variable
|
| TDmlEventItem
Create trigger dml event: delete, insert, update [of columns]
|
| TExecParameter
Parameter of execute statement in SQL Server,teradata
|
| TExecParameterList |
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TExpressionList |
| TForUpdate
The FOR UPDATE clause lets you lock the selected rows so that other users cannot lock
or update the rows until you end your transaction.
|
| TFunctionCall
Represents the database function, all functions are represented by this class no matter what's type of the function.
|
| TGroupBy
This class represents group by clause and having clause.
|
| TGroupByItem |
| TGroupingSet
GROUPING SETS are a further extension of the GROUP BY clause that let you specify multiple groupings of data.
|
| TGroupingSetItem
Gruping set item that used in TGroupingSet
Content of this item can be a TRollupCube instance or a TGroupingExpressionItem instance
|
| THierarchical
Oracle hierarchical_query_clause lets you select rows in a hierarchical order.
|
| TInsertCondition |
| TInsertIntoValue |
| TIntoClause |
| TJoin
Deprecated.
As of v2.7.4.0, Please use
TJoinExpr instead.
A list of join TCustomSqlStatement.joins represents table sources in following clauses of SQL statement:
Each table source in from clause was treated as a join which is type of TJoin.
The reason for this design is that we can treat all table sources in from clause in a uniform way. |
| TJoinItem
Deprecated.
As of v2.7.4.0, Please use
TJoinExpr instead.
SQL 1: In above SQL, the whole from clause can be represented by aselect f from t1 left join t2 on t1.f1 = t2.f1 right join t3 on t1.f1 = t3.f1 TJoin class.
And "left join t2 on t1.f1 = t2.f1 right join t3 on t1.f1 = t3.f1" was represented by 2 instance of class These 2 instance can be accessed via One for: "left join t2 on t1.f1 = t2.f1", the other is "right join t3 on t1.f1 = t3.f1". |
| TKeepDenseRankClause
Oracle keep dense rank clause used in analytic function.
|
| TKeyAction |
| TKeyReference |
| TLimitClause |
| TMergeDeleteClause |
| TMergeInsertClause
insert clause in merge statement.
|
| TMergeUpdateClause
update clause in merge statement.
|
| TMergeWhenClause
when [not] matched clause in merge statement.
|
| TMySQLCreateTableOption |
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList
List of TObjectName
|
| TOrderBy
List of order by item which is type of
TOrderByItem. |
| TOrderByItem
Item in order by clause.
|
| TOrderByItemList |
| TParameterDeclaration
Parameters in create procedure/function statements.
|
| TParameterDeclarationList
List of
TParameterDeclaration. |
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| TPivotClause
use the PIVOT and UNPIVOT relational operators to change a table-valued expression into another table.
|
| TPivotedTable |
| TPivotInClause |
| TPTNodeList |
| TRestrictionClause
Oracle, DB2 restrict clause in create view statement
|
| TResultColumn
This class represents select_list item in select statement, lets you specify the columns you want to retrieve from the table.
|
| TReturningClause |
| TRollupCube
The ROLLUP operation in the simple_grouping_clause groups the selected rows based on the values of the first n, n-1, n-2, ...
|
| TSelectModifier |
| TSimpleDmlTriggerClause |
| TTable
Represents various kinds of table source in from clause.
|
| TTopClause
Indicates that only a specified first set or percent of rows will be returned from the query result set.
|
| TTypeName
This class represents SQL Datatype.
|
| TUnpivotInClause |
| TUnpivotInClauseItem |
| TViewAliasClause |
| TWhenClauseItem
WhenClause item used in case expr of
TCaseExpression. |
| TWhereClause |
| TWindowDef
Represents over clause in analytic function.
|
| TWindowFrame |
| TWindowFrameBoundary |
| TWithinGroup
Oracle within group clause used in analytic function
|
| Class and Description |
|---|
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TTypeName
This class represents SQL Datatype.
|
| Class and Description |
|---|
| EHiveInsertType |
| TAlterTableOptionList
alter table options
|
| TAlterTypeOption |
| TAuthorizationClause |
| TBaseTablePartition
Base partition of all table partitions, such as range_partitions, list_partitions,
hash_partitions,composite_range_partitions and etc
|
| TBindArgumentList
List of
TBindArgument |
| TBlockSqlNode
TBlockSqlNode represents a block in a stored procedure.
|
| TCaseExpression
CASE expressions let you use IF ...
|
| TClusterBy |
| TColumnDefinitionList |
| TComputeClause
SQL Server compute clause, including a list of compute clause item which is in syntax:
COMPUTE [compute_expr_list] [BY by_expr_list]
|
| TConstant
SQL constant (sometimes called a literal) specifies a value.
|
| TConstraintList
List of
TConstraint. |
| TCreateIndexSqlNode |
| TCreateTableOption |
| TDistributeBy |
| TDropIndexItemList |
| TDummy |
| TExceptionClause
Including a list of
TExceptionHandler that process raised exceptions. |
| TExecParameterList |
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TExpressionList |
| TFetchFirstClause
DB2 fetch first clause.
|
| TForUpdate
The FOR UPDATE clause lets you lock the selected rows so that other users cannot lock
or update the rows until you end your transaction.
|
| TFromClause |
| TFunctionCall
Represents the database function, all functions are represented by this class no matter what's type of the function.
|
| TFunctionHeader
A structure includes function name and arguments
|
| TGroupBy
This class represents group by clause and having clause.
|
| THierarchical
Oracle hierarchical_query_clause lets you select rows in a hierarchical order.
|
| THintClause
Hint clause in Hana
|
| TInsertCondition |
| TInsertIntoValue |
| TIntoClause |
| TIntoTableClause
Informix, into table clause.
|
| TIsolationClause
DB2/Sybase isolation clause
|
| TJoinList |
| TLimitClause |
| TLockingClause
Postgresql locking clause
|
| TMergeInsertClause
insert clause in merge statement.
|
| TMergeUpdateClause
update clause in merge statement.
|
| TMergeWhenClause
when [not] matched clause in merge statement.
|
| TMultiTargetList
Represents one or more rows in the values clause of insert statement, or in the values() clause.
|
| TMySQLCreateTableOption |
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList
List of TObjectName
|
| TOffsetClause
PostgreSQL offset clause in select limit
Oracle offset clause in select |
| TOrderBy
List of order by item which is type of
TOrderByItem. |
| TOrderByItemList |
| TParameterDeclarationList
List of
TParameterDeclaration. |
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| TPartitionExtensionClause
Hive, Impala, MySQL, Oracle partition clause in from table
|
| TPTNodeList |
| TQualifyClause
teradata qualify clause
|
| TRestrictionClause
Oracle, DB2 restrict clause in create view statement
|
| TResultColumn
This class represents select_list item in select statement, lets you specify the columns you want to retrieve from the table.
|
| TResultColumnList |
| TReturningClause |
| TSampleClause |
| TSelectDistinct |
| TSelectModifier |
| TSelectSqlNode
Internal used by parser, reprsents raw parse tree node of select statement.
|
| TSequenceOption |
| TSetAssignment |
| TSortBy |
| TStageLocation |
| TStatementListSqlNode |
| TTable
Represents various kinds of table source in from clause.
|
| TTableElementList |
| TTableProperties
Oracle table properties
|
| TTeradataWithClause |
| TTriggeringClause
Trigger clause including:
action time: before, after, instead of
event type: insert, delete, update, ddl event, database event,
TDmlEventClause
referencing clause: old, new ,parent
There are 3 types of triggering clause: simple dml, compound dml, non-dml. |
| TTypeName
This class represents SQL Datatype.
|
| TValueClause
represents values() clause.
|
| TViewAliasClause |
| TWhenClauseItemList
List of
TWhenClauseItem |
| TWhereClause |
| TWindowClause |
| Visitable |
| Class and Description |
|---|
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| Visitable |
| Class and Description |
|---|
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TObjectNameList
List of TObjectName
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| Visitable |
| Class and Description |
|---|
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| Visitable |
| Class and Description |
|---|
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TOrderBy
List of order by item which is type of
TOrderByItem. |
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| TPTNodeList |
| TTable
Represents various kinds of table source in from clause.
|
| Visitable |
| Class and Description |
|---|
| TDeclareVariableList
List of declare variable
|
| TElseIfSqlNodeList |
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TExpressionList |
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList
List of TObjectName
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| TPTNodeList |
| TSetAssignment |
| TTable
Represents various kinds of table source in from clause.
|
| TTypeName
This class represents SQL Datatype.
|
| TWhenClauseItemList
List of
TWhenClauseItem |
| Visitable |
| Class and Description |
|---|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| Visitable |
| Class and Description |
|---|
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| Visitable |
| Class and Description |
|---|
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList
List of TObjectName
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| TPartitionExtensionClause
Hive, Impala, MySQL, Oracle partition clause in from table
|
| TPTNodeList |
| TTable
Represents various kinds of table source in from clause.
|
| Visitable |
| Class and Description |
|---|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| Visitable |
| Class and Description |
|---|
| TColumnDefinitionList |
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| Visitable |
| Class and Description |
|---|
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| TPTNodeList |
| Visitable |
| Class and Description |
|---|
| TBlockSqlNode
TBlockSqlNode represents a block in a stored procedure.
|
| TColumnDefinitionList |
| TConstant
SQL constant (sometimes called a literal) specifies a value.
|
| TDeclareVariableList
List of declare variable
|
| TExecParameterList |
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TExpressionList |
| TFunctionCall
Represents the database function, all functions are represented by this class no matter what's type of the function.
|
| THandlerForCondition
Teradata handler for clause
|
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList
List of TObjectName
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| TTable
Represents various kinds of table source in from clause.
|
| TTypeName
This class represents SQL Datatype.
|
| Visitable |
| Class and Description |
|---|
| TDeclareVariableList
List of declare variable
|
| TElseIfSqlNodeList |
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TExpressionList |
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList
List of TObjectName
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| TPTNodeList |
| TSetAssignment |
| TTable
Represents various kinds of table source in from clause.
|
| TTypeName
This class represents SQL Datatype.
|
| TWhenClauseItemList
List of
TWhenClauseItem |
| Visitable |
| Class and Description |
|---|
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList
List of TObjectName
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| Visitable |
| Class and Description |
|---|
| TCallSpec
Call specification in PLSQL when define a function
|
| TConstant
SQL constant (sometimes called a literal) specifies a value.
|
| TDummy |
| TDummyList |
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TExpressionList |
| TFunctionCall
Represents the database function, all functions are represented by this class no matter what's type of the function.
|
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList
List of TObjectName
|
| TParameterDeclarationList
List of
TParameterDeclaration. |
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| TPTNodeList |
| TStatementListSqlNode |
| TTriggeringClause
Trigger clause including:
action time: before, after, instead of
event type: insert, delete, update, ddl event, database event,
TDmlEventClause
referencing clause: old, new ,parent
There are 3 types of triggering clause: simple dml, compound dml, non-dml. |
| TTypeAttributeList
List of attribute definition (
TTypeAttribute) of an object type. |
| TTypeName
This class represents SQL Datatype.
|
| Visitable |
| Class and Description |
|---|
| TConstant
SQL constant (sometimes called a literal) specifies a value.
|
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TFunctionCall
Represents the database function, all functions are represented by this class no matter what's type of the function.
|
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList
List of TObjectName
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| TStatementListSqlNode |
| TTable
Represents various kinds of table source in from clause.
|
| Visitable |
| Class and Description |
|---|
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| Visitable |
| Class and Description |
|---|
| TAuthorizationClause |
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList
List of TObjectName
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| TTypeNameList |
| Visitable |
| Class and Description |
|---|
| TDummy |
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList
List of TObjectName
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| TStageLocation |
| Visitable |
| Class and Description |
|---|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| Visitable |
| Class and Description |
|---|
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList
List of TObjectName
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| Visitable |
| Class and Description |
|---|
| TColumnDefinitionList |
| TExecParameterList |
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| TTable
Represents various kinds of table source in from clause.
|
| Visitable |
| Class and Description |
|---|
| TConstant
SQL constant (sometimes called a literal) specifies a value.
|
| TExpression
An expression is a combination of one or more values, operators, and SQL functions that evaluates to a value.
|
| TNameValuePair |
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TObjectNameList
List of TObjectName
|
| TParseTreeNode
This class is the root class for all syntax/parse tree nodes.
|
| TParseTreeVisitor |
| TPTNodeList |
| TTypeName
This class represents SQL Datatype.
|
| Visitable |
| Class and Description |
|---|
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| Class and Description |
|---|
| TObjectName
The qualified or unqualified name that identifies a database object.
|
| TParseTreeVisitor |