Class TCreateIndexSqlStatement

Namespace

gudusoft.gsqlparser.stmt

Assembly

gudusoft.gsqlparser.dll

create an index.

public class TCreateIndexSqlStatement : TCustomSqlStatement, Visitable

Inheritance

object

TParseTreeNode

TCustomSqlStatement

TCreateIndexSqlStatement

Implements

Visitable

Inherited Members

TCustomSqlStatement.RewriteInit()

TCustomSqlStatement.OracleHint

TCustomSqlStatement.Hint

TCustomSqlStatement.scanOracleHint(TSourceToken)

TCustomSqlStatement.DatabaseObjects

TCustomSqlStatement.setLabelName(TObjectName)

TCustomSqlStatement.setEndlabelName(TObjectName)

TCustomSqlStatement.LabelName

TCustomSqlStatement.EndLabelName

TCustomSqlStatement.sqlstatementtype

TCustomSqlStatement.sourcetokenlist

TCustomSqlStatement.parser

TCustomSqlStatement.plsqlparser

TCustomSqlStatement.stmtDummyTag

TCustomSqlStatement.TargetTable

TCustomSqlStatement.joins

TCustomSqlStatement.tables

TCustomSqlStatement.Statements

TCustomSqlStatement.CteList

TCustomSqlStatement.ResultColumnList

TCustomSqlStatement.ReturningClause

TCustomSqlStatement.OutputClause

TCustomSqlStatement.TopClause

TCustomSqlStatement.WhereClause

TCustomSqlStatement.addWhereClause(string)

TCustomSqlStatement.searchCTEList()

TCustomSqlStatement.ParentStmt

TCustomSqlStatement.AncestorStmt

TCustomSqlStatement.rootNode

TCustomSqlStatement.SymbolTable

TCustomSqlStatement.isparsed

TCustomSqlStatement.ErrorCount

TCustomSqlStatement.parseerrormessagehandle(TSyntaxError)

TCustomSqlStatement.parsestatement(TCustomSqlStatement, bool)

TCustomSqlStatement.OracleStatementCanBeSeparatedByBeginEndPair()

TCustomSqlStatement.isnzplsql()

TCustomSqlStatement.ispgplsql()

TCustomSqlStatement.isoracleplsql()

TCustomSqlStatement.dochecksyntax(TCustomSqlStatement)

TCustomSqlStatement.clearError()

TCustomSqlStatement.analyzeTablename(TObjectName)

TCustomSqlStatement.isTableACTE(TTable)

TCustomSqlStatement.findTable(ETableEffectType)

TCustomSqlStatement.addToTables(TTable)

TCustomSqlStatement.analyzeFromTable(TFromTable, bool?)

TCustomSqlStatement.analyzeJoin(TJoinExpr, TJoin, bool?)

TCustomSqlStatement.locateVariableOrParameter(TObjectName)

TCustomSqlStatement.fireOnMetaDatabaseTableColumn(string, string, string, string, string)

TCustomSqlStatement.FirstPhysicalTable

TCustomSqlStatement.OrphanColumns

TCustomSqlStatement.linkToFirstTable(TObjectName, int)

TCustomSqlStatement.linkColumnToTable(TObjectName, ESqlClause)

TCustomSqlStatement.linkColumnReferenceToTable(TObjectName, ESqlClause)

TCustomSqlStatement.checkNonQualifiedColumnReferenceInSubQueryOfUplevelStmt(TObjectName, bool)

TCustomSqlStatement.TopStatement

TParseTreeNode.dbvendor

TParseTreeNode.IsIncludingOriginalTokens()

TParseTreeNode.setChanged()

TParseTreeNode.IsUnderlyingTokenChanged()

TParseTreeNode.Gsqlparser

TParseTreeNode.IncludingComment

TParseTreeNode.DummyTag

TParseTreeNode.startToken

TParseTreeNode.getStartToken()

TParseTreeNode.getEndToken()

TParseTreeNode.endToken

TParseTreeNode.ColumnNo

TParseTreeNode.LineNo

TParseTreeNode.NodeType

TParseTreeNode.init(object)

TParseTreeNode.init(object, object)

TParseTreeNode.init(object, object, object)

TParseTreeNode.init(object, object, object, object)

TParseTreeNode.init(object, object, object, object, object)

TParseTreeNode.init(object, object, object, object, object, object)

TParseTreeNode.doParse(TCustomSqlStatement, ESqlClause)

TParseTreeNode.setStartToken(TSourceToken)

TParseTreeNode.setStartToken(TParseTreeNode)

TParseTreeNode.setStartToken<T>(List<T>)

TParseTreeNode.setEndToken(TSourceToken)

TParseTreeNode.setEndToken(TParseTreeNode)

TParseTreeNode.setEndToken<T>(List<T>)

TParseTreeNode._stringValue

TParseTreeNode.String

TParseTreeNode.SourceTokenList

TParseTreeNode.ToString(bool)

TParseTreeNode.ToString()

TParseTreeNode.ToScript()

TParseTreeNode.addAllMyTokensToTokenList(TSourceTokenList, int)

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.MemberwiseClone()

object.ReferenceEquals(object, object)

Constructors

TCreateIndexSqlStatement(EDbVendor)

public TCreateIndexSqlStatement(EDbVendor dbvendor)

Parameters

dbvendor EDbVendor

Properties

AsTypeName

public virtual TObjectName AsTypeName { get; set; }

Property Value

TObjectName

Clustered

public virtual bool Clustered { get; set; }

Property Value

bool

ColumnNameList

public virtual TOrderByItemList ColumnNameList { get; set; }

Property Value

TOrderByItemList

CreateIndexNode

public virtual TCreateIndexSqlNode CreateIndexNode { get; }

Property Value

TCreateIndexSqlNode

DeferredRebuildIndex

public virtual bool DeferredRebuildIndex { get; set; }

Property Value

bool

FilegroupOrPartitionSchemeName

public virtual TObjectName FilegroupOrPartitionSchemeName { get; set; }

Property Value

TObjectName

FilterPredicate

public virtual TExpression FilterPredicate { get; set; }

Property Value

TExpression

InTableName

public virtual TObjectName InTableName { get; set; }

Property Value

TObjectName

IndexComment

public virtual TObjectName IndexComment { get; set; }

Property Value

TObjectName

IndexName

public virtual TObjectName IndexName { get; set; }

Property Value

TObjectName

the name of the index to be created.

IndexOptionList

public List<TMySQLIndexOption> IndexOptionList { get; set; }

Property Value

List<TMySQLIndexOption>

IndexProperties

public virtual THiveIndexProperties IndexProperties { get; set; }

Property Value

THiveIndexProperties

IndexType

public virtual EIndexType IndexType { get; set; }

Property Value

EIndexType

NonClustered

public virtual bool NonClustered { get; set; }

Property Value

bool

PartitionSchemeColumns

public virtual TObjectNameList PartitionSchemeColumns { get; set; }

Property Value

TObjectNameList

TableFileFormat

public virtual THiveTableFileFormat TableFileFormat { get; set; }

Property Value

THiveTableFileFormat

TableLocation

public virtual TObjectName TableLocation { get; set; }

Property Value

TObjectName

TableName

public virtual TObjectName TableName { get; set; }

Property Value

TObjectName

TableProperties

public virtual THiveTableProperties TableProperties { get; set; }

Property Value

THiveTableProperties

TableRowFormat

public virtual THiveRowFormat TableRowFormat { get; set; }

Property Value

THiveRowFormat

includeColumns

public virtual TObjectNameList includeColumns { get; set; }

Property Value

TObjectNameList

Methods

accept(TParseTreeVisitor)

public override void accept(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

acceptChildren(TParseTreeVisitor)

public override void acceptChildren(TParseTreeVisitor v)

Parameters

v TParseTreeVisitor

doParseStatement(TCustomSqlStatement)

analyze SQL

public override int doParseStatement(TCustomSqlStatement psql)

Parameters

psql TCustomSqlStatement

Returns

int