Where Clause

Description

Specifies a condition that selects the rows to be deleted. The clause can be omitted, a search condition specified, or a cursor named. If the clause is omitted, all rows of the table or view are deleted.

All the grammar specified in this Where clause of DB2 is ANSI compliant, equivalent to Snowflake, and is therefore translated as is by SnowConvert.

Click here to navigate to the IBM DB2 docs page for this syntax.

Grammar Syntax

Sample Source Patterns

IBM DB2

Statement

DELETE FROM table1 Where 1>0

Snowflake

Statement

DELETE FROM
PUBLIC.table1
Where 1>0