urQL/docs/08-delete.md

DELETE

supported in urQL parser, not yet supported in Obelisk

Deletes rows from a <table-set>.

<delete> ::=
  DELETE [ FROM ] <table>
    [ WHERE <predicate> ]
  [ <as-of-time> ]

API

+$  delete
  $:
    %delete
    table=qualified-object
    predicate=(unit predicate)
    as-of=(unit as-of)
  ==

Arguments

<table> The target of the DELETE operation.

<predicate> Any valid <predicate>, including predicates on CTEs.

<as-of-time> Timestamp of table creation. Defaults to NOW (current time). When specified, the timestamp must be greater than both the latest database schema and content timestamps.

Remarks

This command mutates the state of the Obelisk agent.

Data in the sys namespace cannot be deleted.

Produced Metadata

Row count Content timestamp

Exceptions

delete state change after query in script database <database> does not exist delete from table <table> as-of data time out of order delete from table <table> as-of schema time out of order table <namespace>.<table> does not exist delete invalid predicate: <predicate> GRANT permission on <table> violated