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

Fullselect

Snowflake

Table Name

DELETE FROM Table1;

Only

Fullselect

Related EWIs

1. MSCEWI5004: ONLY OUTER TABLE REFERENCE IS NOT APPLICABLE IN SNOWFLAKE.

2. MSCEWI5008: DELETE FROM SELECT STATEMENT IS NOT SUPPORTED.