Table of Contents

Class TTable

Namespace
gudusoft.gsqlparser.nodes
Assembly
gudusoft.gsqlparser.dll

Represents various kinds of table source in from clause. Can also be a simple table/view name in create table and all other places. result of TableType can be one of:

  • ftt_objectname, in from clause, a simple table/view name, reference: gudusoft.gsqlparser.nodes.TTable._tableName
  • ftt_subquery, is a subquery that retrieves rows from the database, also known as derived table. reference: Subquery
  • ftt_tableExpr,it's usually a table-valued expression., reference: gudusoft.gsqlparser.nodes.TTable.tableExpr
  • ftt_function, it's usually a table-valued function., reference: gudusoft.gsqlparser.nodes.TTable.funcCall
  • rowList, it's constructed rows, reference: gudusoft.gsqlparser.nodes.TTable.rowList
  • ftt_containsTable, CONTAINSTABLE clause of sql server. reference: gudusoft.gsqlparser.nodes.TTable.containsTable, type of TContainsTable
  • ftt_freetextTable, FREETEXTTABLE clause of sql server. reference: gudusoft.gsqlparser.nodes.TTable.containsTable, type of TContainsTable
  • ftt_openrowset, OPENROWSET clause of sql server. reference: gudusoft.gsqlparser.nodes.TTable.openRowSet, type of TOpenRowSet
  • ftt_openxml, OPENXML clause of sql server. reference: gudusoft.gsqlparser.nodes.TTable.openXML, type of TOpenXML
  • ftt_opendatasource, OPENDATASOURCE clause of sql server. reference: gudusoft.gsqlparser.nodes.TTable.openDatasource, type of TOpenDatasource
  • ftt_openquery, OPENQUERY clause of sql server. reference: gudusoft.gsqlparser.nodes.TTable.openquery, type of TOpenQuery 
public class TTable : TNodeWithAliasClause, Visitable
Inheritance
TTable
Implements
Inherited Members

Constructors

TTable() 

public TTable()

TTable(TObjectName) 

public TTable(TObjectName pobjectname)

Parameters

pobjectname TObjectName

Properties

AliasName 

public virtual string AliasName { get; }

Property Value

string

BaseTable 

public virtual bool BaseTable { get; }

Property Value

bool

CTE 

public virtual TCTE CTE { get; set; }

Property Value

TCTE

CTEName 

public virtual bool CTEName { get; set; }

Property Value

bool

ContainsTable 

public virtual TContainsTable ContainsTable { get; set; }

Property Value

TContainsTable

CteColomnReferences 

public virtual TObjectNameList CteColomnReferences { get; set; }

Property Value

TObjectNameList

DatachangeTable 

public virtual TDataChangeTable DatachangeTable { get; set; }

Property Value

TDataChangeTable

EffectType 

public virtual ETableEffectType EffectType { get; set; }

Property Value

ETableEffectType

Flashback 

public virtual TFlashback Flashback { get; set; }

Property Value

TFlashback

FromTableList 

public virtual TFromTableList FromTableList { get; set; }

Property Value

TFromTableList

FullName 

public virtual string FullName { get; }

Property Value

string

FullNameWithAliasString 

public virtual string FullNameWithAliasString { get; }

Property Value

string

FuncCall 

public virtual TFunctionCall FuncCall { get; set; }

Property Value

TFunctionCall

HiveFromQuery 

public virtual THiveFromQuery HiveFromQuery { get; set; }

Property Value

THiveFromQuery

IncludeColumnAlias 

public virtual bool IncludeColumnAlias { get; }

Property Value

bool

IndexHintList 

public List<TIndexHint> IndexHintList { get; set; }

Property Value

List<TIndexHint>

JsonTable 

public TJsonTable JsonTable { get; set; }

Property Value

TJsonTable

LateralKeyword 

public virtual bool LateralKeyword { get; set; }

Property Value

bool

LateralViewList 

public virtual List<THiveLateralView> LateralViewList { get; set; }

Property Value

List<THiveLateralView>

LinkTable 

public virtual TTable LinkTable { get; }

Property Value

TTable

LinkedColumns 

public virtual TObjectNameList LinkedColumns { get; set; }

Property Value

TObjectNameList

Name 

public virtual string Name { get; }

Property Value

string

ObjectNameReferences 

public virtual TObjectNameList ObjectNameReferences { get; set; }

Property Value

TObjectNameList

OnlyKeyword 

public virtual bool OnlyKeyword { get; set; }

Property Value

bool

OpenDatasource 

public virtual TOpenDatasource OpenDatasource { get; set; }

Property Value

TOpenDatasource

OpenRowSet 

public virtual TOpenRowSet OpenRowSet { get; set; }

Property Value

TOpenRowSet

OpenXML 

public virtual TOpenXML OpenXML { get; set; }

Property Value

TOpenXML

Openquery 

public virtual TOpenQuery Openquery { get; set; }

Property Value

TOpenQuery

OuterClause 

public virtual TInformixOuterClause OuterClause { get; set; }

Property Value

TInformixOuterClause

OutputMerge 

public virtual TMergeSqlStatement OutputMerge { get; set; }

Property Value

TMergeSqlStatement

ParenthesisAfterAliasCount 

public virtual int ParenthesisAfterAliasCount { get; set; }

Property Value

int

ParenthesisCount 

public virtual int ParenthesisCount { get; set; }

Property Value

int

PartitionExtensionClause 

public virtual TPartitionExtensionClause PartitionExtensionClause { get; set; }

Property Value

TPartitionExtensionClause

PivotClause 

public virtual TPivotClause PivotClause { get; set; }

Property Value

TPivotClause

PivotedTable 

public virtual TPivotedTable PivotedTable { get; set; }

Property Value

TPivotedTable

PrefixDatabase 

public virtual string PrefixDatabase { get; }

Property Value

string

PrefixSchema 

public virtual string PrefixSchema { get; }

Property Value

string

PrefixServer 

public virtual string PrefixServer { get; }

Property Value

string

PxGranule 

public virtual TPxGranule PxGranule { get; set; }

Property Value

TPxGranule

RowList

row constructor like this: '(' RW_VALUES MultiTargets ')'

public virtual TMultiTargetList RowList { get; set; }

Property Value

TMultiTargetList

TMultiTargetList

Subquery 

public virtual TSelectSqlStatement Subquery { get; set; }

Property Value

TSelectSqlStatement

TableExpr 

public virtual TExpression TableExpr { get; set; }

Property Value

TExpression

TableHintList 

public virtual List<TTableHint> TableHintList { get; set; }

Property Value

List<TTableHint>

TableKeyword 

public virtual bool TableKeyword { get; set; }

Property Value

bool

TableName 

public virtual TObjectName TableName { get; set; }

Property Value

TObjectName

TableProperties 

public virtual List<THiveKeyValueProperty> TableProperties { get; set; }

Property Value

List<THiveKeyValueProperty>

TableSample 

public virtual TTableSample TableSample { get; set; }

Property Value

TTableSample

TableType 

public virtual ETableSource TableType { get; set; }

Property Value

ETableSource

Tablerefs 

public virtual TTableReferenceList Tablerefs { get; set; }

Property Value

TTableReferenceList

XmlTable 

public virtual TXmlTable XmlTable { get; set; }

Property Value

TXmlTable

Methods

accept(TParseTreeVisitor) 

public override void accept(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

acceptChildren(TParseTreeVisitor) 

public override void acceptChildren(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

equalByName(string) 

public virtual bool equalByName(string pTableName)

Parameters

pTableName string

Returns

bool

isLinkTable() 

public virtual bool isLinkTable()

Returns

bool

isTableRefBelongToThisTable(TTableReference) 

public virtual bool isTableRefBelongToThisTable(TTableReference tableref)

Parameters

tableref TTableReference

Returns

bool

searchColumnInAlias(TObjectName) 

public virtual bool searchColumnInAlias(TObjectName pColumn)

Parameters

pColumn TObjectName

Returns

bool

setLinkTable(bool) 

public virtual void setLinkTable(bool isLinkTable)

Parameters

isLinkTable bool

setLinkTable(TTable) 

public virtual void setLinkTable(TTable linkTable)

Parameters

linkTable TTable
Edit this page