gudusoft.gsqlparser.stmt
Class TDeleteSqlStatement

java.lang.Object
  extended by gudusoft.gsqlparser.nodes.TParseTreeNode
      extended by gudusoft.gsqlparser.TCustomSqlStatement
          extended by gudusoft.gsqlparser.stmt.TDeleteSqlStatement
All Implemented Interfaces:
Visitable

public class TDeleteSqlStatement
extends TCustomSqlStatement

Use the DELETE statement to remove rows from:

Note: Transact-SQL extension to DELETE allows specifying data from and deleting the corresponding rows from the table in the first FROM clause.

This extension, specifying a join, can be used instead of a subquery in the WHERE clause to identify rows to be removed.

See Also:
TCustomSqlStatement.cteList, TCustomSqlStatement.topClause, TCustomSqlStatement.targetTable, TCustomSqlStatement.joins, TCustomSqlStatement.whereClause, TCustomSqlStatement.returningClause, TCustomSqlStatement.outputClause

Field Summary
 
Fields inherited from class gudusoft.gsqlparser.TCustomSqlStatement
dbvendor, dummytag, joins, parser, plsqlparser, rootNode, sourcetokenlist, sqlstatementtype, tables
 
Constructor Summary
TDeleteSqlStatement(EDbVendor dbvendor)
           
 
Method Summary
 void accept(TParseTreeVisitor v)
           
 int doParseStatement(TCustomSqlStatement psql)
           
 TSourceToken getDeleteToken()
           
 TLimitClause getLimitClause()
           
 TOrderBy getOrderByClause()
           
 TJoinList getReferenceJoins()
          MySQL syntax: delete table_name1.[*],table_name2.[*] ...
 void setDeleteToken(TSourceToken deleteToken)
           
 
Methods inherited from class gudusoft.gsqlparser.TCustomSqlStatement
addWhereClause, analyzeFromTable, analyzeJoin, analyzeTablename, checkNonQualifiedColumnReferenceInSubQueryOfUplevelStmt, getCteList, getErrorCount, getLabelName, getOutputClause, getParentStmt, getResultColumnList, getReturningClause, getStatements, getSymbolTable, getTargetTable, getTopClause, getTopStatement, getWhereClause, isnzplsql, isoracleplsql, ispgplsql, linkColumnReferenceToTable, locateVariableOrParameter, OracleStatementCanBeSeparatedByBeginEndPair, parsestatement, setCteList, setLabelName, setOutputClause, setParentStmt, setResultColumnList, setReturningClause, setTargetTable, setTopClause, setWhereClause
 
Methods inherited from class gudusoft.gsqlparser.nodes.TParseTreeNode
addAllMyTokensToTokenList, doParse, getColumnNo, getDummyTag, getEndToken, getGsqlparser, getLineNo, getNodeType, getStartToken, init, init, init, init, init, init, setDummyTag, setEndToken, setEndToken, setGsqlparser, setNodeType, setStartToken, setStartToken, setString, toString
 
Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, wait, wait, wait
 

Constructor Detail

TDeleteSqlStatement

public TDeleteSqlStatement(EDbVendor dbvendor)
Method Detail

setDeleteToken

public void setDeleteToken(TSourceToken deleteToken)

getDeleteToken

public TSourceToken getDeleteToken()

getOrderByClause

public TOrderBy getOrderByClause()

getLimitClause

public TLimitClause getLimitClause()

getReferenceJoins

public TJoinList getReferenceJoins()
MySQL syntax: delete table_name1.[*],table_name2.[*] ... from table_references

joins represents: table_name1.[*],table_name2.[*] ...

getReferenceJoins() represents: table_references

Returns:

doParseStatement

public int doParseStatement(TCustomSqlStatement psql)
Overrides:
doParseStatement in class TCustomSqlStatement

accept

public void accept(TParseTreeVisitor v)
Specified by:
accept in interface Visitable
Overrides:
accept in class TParseTreeNode