Table of Contents

Class TDeleteSqlStatement

Namespace
gudusoft.gsqlparser.stmt
Assembly
gudusoft.gsqlparser.dll

This class represents delete statement.

  DELETE FROM Production.ProductCostHistory
  WHERE StandardCost > 1000.00;

Production.ProductCostHistory can be fetched from TargetTable or tables or joins 

 DELETE FROM Sales.SalesPersonQuotaHistory
 FROM Sales.SalesPersonQuotaHistory AS spqh
 INNER JOIN Sales.SalesPerson AS sp
 ON spqh.BusinessEntityID = sp.BusinessEntityID
 WHERE sp.SalesYTD > 2500000.00;

Sales.SalesPersonQuotaHistory AS spqh should be fetched froom ReferenceJoins

public class TDeleteSqlStatement : TCustomSqlStatement, Visitable
Inheritance
TDeleteSqlStatement
Implements
Inherited Members

Constructors

TDeleteSqlStatement(EDbVendor) 

public TDeleteSqlStatement(EDbVendor dbvendor)

Parameters

dbvendor EDbVendor

Properties

DeleteToken 

public virtual TSourceToken DeleteToken { get; set; }

Property Value

TSourceToken

ErrorLoggingClause 

public virtual TErrorLoggingClause ErrorLoggingClause { get; set; }

Property Value

TErrorLoggingClause

FromKeyword 

public virtual bool FromKeyword { get; set; }

Property Value

bool

LimitClause 

public virtual TLimitClause LimitClause { get; set; }

Property Value

TLimitClause

OptionClause

sql server option clause

public virtual TOptionClause OptionClause { get; set; }

Property Value

TOptionClause

TOptionClause

See Also

OrderByClause 

public virtual TOrderBy OrderByClause { get; set; }

Property Value

TOrderBy

ReferenceJoins

MySQL syntax: delete table_name1.[],table_name2.[] ... from table_references

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

getReferenceJoins() represents: table_references 

public virtual TJoinList ReferenceJoins { get; set; }

Property Value

TJoinList

list of TJoin

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)

Used internal.

public override int doParseStatement(TCustomSqlStatement psql)

Parameters

psql TCustomSqlStatement

input sql.

Returns

int

zero if no syntax error detected.

Edit this page