Liking cljdoc? Tell your friends :D

Delete Statement Representation

Below is a map showing the structure of a delete statement. The first two keys are required.

{:sql-stmt :delete
 :source ...name...
 :as ...name...
 :indexed-by ...name-or-nil...
 :where ...expr...
 :order-by ...order-item-list...
 :limit ...expr...
 :offset ...expr...}

FROM Clause

...source... is the table name (required)

...as... is an optional alias

:indexed-by is an optional index name

Here’s how :indexed-by would be used…​

{:source :tbl}
;; FROM tbl
{:source :tbl :indexed-by nil}
;; FROM tbl NOT INDEXED
{:source :tbl :indexed-by :ix}
;; FROM tbl INDEXED BY ix

Other Clauses

The remaining clauses have the same meaning as in select statements.

SQLite optionally allows ORDER BY, LIMIT and OFFSET clauses, but they may not be standard SQL.

❮Composing StatementsInsert Statement Representation❯

Can you improve this documentation?Edit on GitHub

cljdoc builds & hosts documentation for Clojure/Script libraries

Keyboard shortcuts
Ctrl+kJump to recent docs
←Move to previous article
→Move to next article
Ctrl+/Jump to the search field
Raise an issueBrowse cljdoc sourceChat on Slack
× close