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.
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
Snowflake
Related EWIs
Last updated