gudusoft.gsqlparser.stmt
Class TDeleteSqlStatement
java.lang.Object
gudusoft.gsqlparser.nodes.TParseTreeNode
gudusoft.gsqlparser.TCustomSqlStatement
gudusoft.gsqlparser.stmt.TDeleteSqlStatement
- All Implemented Interfaces:
- Visitable
public class TDeleteSqlStatement
- extends TCustomSqlStatement
Use the DELETE statement to remove rows from:
- An unpartitioned or partitioned table
- The unpartitioned or partitioned base table of a view
- The unpartitioned or partitioned container table of a writable materialized view
- The unpartitioned or partitioned master table of an updatable materialized view
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
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 |
TDeleteSqlStatement
public TDeleteSqlStatement(EDbVendor dbvendor)
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