Delete
delete
– remove objects from a database.
[ with with-item [, ...] ]
delete expr
[ filter filter-expr ]
[ order by order-expr [direction] [then ...] ]
[ offset offset-expr ]
[ limit limit-expr ] ;
with
Alias declarations.
The with
clause allows specifying module aliases as well as expression aliases that can be referenced by the delete
statement. See With block for more information.
delete …
The entire delete … statement is syntactic sugar for delete (select ...)
. Therefore, the base expr and the following filter, order by, offset, and limit clauses shape the set to be deleted the same way an explicit select would.
Output
On successful completion, a delete
statement returns the set of deleted objects.
Examples
Here’s a simple example of deleting a specific user:
with module example
delete User
filter User.name = 'Alice Smith';
And here’s the equivalent delete (select ...)
statement:
with module example
delete (select User
filter User.name = 'Alice Smith');
︙
See also |