Delete

Table of Contents

DELETE removes the documents that match the WHERE clause. Without a WHERE clause, every document in the schema is deleted.

Deletes the document with a given Id.

DELETE FROM
    WordList:Word
WHERE
    Id = 1

Deletes documents based on a join. Name the alias of the schema to delete from after DELETE.

DELETE
    w
FROM
    WordList:Word as w
INNER JOIN WordList:Language as l
    ON l.Id = w.LanguageId
WHERE
    l.Name = 'Spanish'

Deletes every document in a schema.

DELETE FROM WordList:EnglishWords

Creates, alters and drops schemas.

Literals, operators, comments and variables in KBSQL.

Insert creates new documents in a schema.

A breakdown of all of the statements and keywords supported by the query processor.

Connects one logical expression to another.

Removed: schemas no longer have a page size.

Select statements are used to read (or query) data from the database.

Update changes fields of existing documents.

The where clause filters the documents read, updated or deleted by a statement.