Delete Target

Description

Identifies the object of the delete operation.

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

Snowflake only allows tables as the object of the update operation. The output query can be malformed.

Grammar Syntax

Sample Source Patterns

IBM DB2

Table Name

DELETE FROM Table1;

Only

DELETE FROM ONLY (Table1);

Fullselect

DELETE FROM (
SELECT * FROM table1
)

Snowflake

Table Name

DELETE FROM Table1;

Only

DELETE FROM
/*** MSC-WARNING - MSCEWI5004 - ONLY TABLE REFERENCE IS NOT APPLICABLE IN SNOWFLAKE. ***/
tableName

Fullselect

DELETE FROM
-- ** MSC-ERROR - MSCEWI5008 - DELETE FROM SELECT STATEMENT IS NOT SUPPORTED. **
--            (
--SELECT * FROM table1
--)

Related EWIs

1. MSCEWI5004: ONLY OUTER TABLE REFERENCE IS NOT APPLICABLE IN SNOWFLAKE.
2. MSCEWI5008: DELETE FROM SELECT STATEMENT IS NOT SUPPORTED.