Delete

Table of Contents


Overview
Delete removes a document from a schema based on a given criteria.

Examples
round-pushpin Statement to delete a document from the Word schema for a given Id.
DELETE FROM
    WordList:Word
WHERE
    Id = 1

round-pushpin Statement to delete all WordList:Word schema documents where the target language is 'English'.
DELETE FROM
    WordList:Word as sw
INNER JOIN WordList:Language as sl
    ON sl.Id = sw.LanguageId
INNER JOIN WordList:Synonym as S
    ON S.SourceWordId = sw.Id
INNER JOIN WordList:Word as tw
    ON tw.Id = S.TargetWordId
INNER JOIN WordList:Language as tl
    ON tl.Id = TW.LanguageId
WHERE
    tl.Name = 'English'

Related