Class DeleteScope

Object
gudusoft.gsqlparser.resolver2.scope.AbstractScope
gudusoft.gsqlparser.resolver2.scope.DeleteScope
All Implemented Interfaces:
IScope

public class DeleteScope extends AbstractScope
Scope for DELETE statement. Contains: - Target table (the DELETE table) - FROM clause scope (optional - for DELETE...FROM syntax in SQL Server) - WHERE clause scope Example (SQL Server): DELETE FROM Sales.SalesPersonQuotaHistory FROM Sales.SalesPersonQuotaHistory AS spqh INNER JOIN Sales.SalesPerson AS sp ON spqh.SalesPersonID = sp.SalesPersonID WHERE sp.SalesYTD > 2500000.00; Resolution strategy: - WHERE clause columns resolve from all visible tables (target table + FROM clause tables) - JOIN ON clause columns resolve from the joined tables