Table of Contents

Enum ESqlClause

Namespace
gudusoft.gsqlparser
Assembly
gudusoft.gsqlparser.dll

Enum for various SQL clause such as where clause, having clause and etc.

public enum ESqlClause

Fields

columnAlias = 38
compute = 9
constraintRef = 35
containsTable = 42
createTable = 34
cte = 23
datachangeTable = 47
distributeBy = 30
elTable = 33
expandOn = 18

teradata expand on clause

forUpdate = 24
groupby = 4
having = 3
hierarchical = 8
index = 31
insertColumn = 36
insertValues = 13

values clause of insert

join = 7
joinCondition = 6
jsontable = 55
limit = 19
lockingClause = 28

postgresql for update of,

mergeInsert = 52
opendatasource = 45
openquery = 46
openrowset = 43
openxml = 44
orderby = 5
outerTable = 51
output = 25

output clause in update statement

parameters = 54
pivoted_table = 49
qualify = 15

teradata qualify clause

resultColumn = 1

can be select list, insert into columns

returning = 26

returning clause in update statement

rowList = 48
sample = 16

SQL Server sample clause

selectInto = 14

into clause in select

selectList = 53
selectValue = 21

value clause in select

set = 12

set clause in update

setValue = 37
setVariable = 27

set variable

sortby = 20

hive sort by clause

tableExpr = 41
tableFunction = 40
tableHint = 32
teradataWith = 17
top = 11

sql server top clause

transformClause = 29
unSet = 39
unknown = 0
viewAlias = 22

view alias in create view statement

where = 2
windowClause = 10
xmltable = 50