DELETE STATEMENT

Description

The DELETE statement deletes rows from a table, nickname, or view, or the underlying tables, nicknames, or views of the specified fullselect.

The use of views, nicknames, and fullselect as targets for an update statement is not supported by Snowflake

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

Grammar Syntax

Navigate to the following pages to get more details about the translation spec for the subsections of the DELETE STATEMENT grammar.

1. Delete Target

2. Common Table Expression

3. Period Clause

4. Correlation Clause

5. Include Columns

6. Assignment Clause

7. Where Clause

8. Order By

9. Offset

10. Fetch

11. With Clause

12. Skip Locked

13. Wait Option

Positioned Deleted

Description

The Positioned DELETE form is used to delete exactly one row (as determined by the current position of a cursor).

The positioned delete is not supported in Snowflake because the use of cursors in the delete statement is not allowed

Grammar Syntax

IBM DB2

DELETE FROM table1 
WHERE CURRENT OF cursor1

Snowflake

-- ** MSC-ERROR - MSCEWI5009 - POSITIONED DELETE IS NOT SUPPORTED. **
--DELETE FROM table1
--WHERE CURRENT OF cursor1

Related EWIs

1. MSCEWI5009: POSITIONED UPDATE IS NOT SUPPORTED.