DELETE

Description

Statement use to delete rows of a table.

Grammar Syntax

[ WITH [ RECURSIVE ] with_query [, ...] ]
DELETE FROM [ ONLY ] table_name [ * ] [ [ AS ] alias ]
    [ USING from_item [, ...] ]
    [ WHERE condition | WHERE CURRENT OF cursor_name ]
    [ RETURNING * | output_expression [ [ AS ] output_name ] [, ...] ]

Click here to go to the PostgreSQL specification for this syntax.

Navigate to the following pages to get more details about the translation spec for DELETE syntax.

1. Using clause