SQL Delete Vertex

SQL Delete vertex

The SQL Delete Vertex command deletes one or more vertices from the database. Use this command if you work against graphs. The "Delete Vertex" (like the Delete Edge) command takes care to remove all the cross references to the vertices in all the edges involved.

Syntax

    DELETE VERTEX <rid>|<[<class>] [WHERE <conditions>] [LIMIT <MaxRecords>>]

The WHERE clause is common to the other SQL commands.

Examples

Deletes the vertex, and disconnects all vertices pointing towards it:

    DELETE VERTEX #10:231

Deletes all user accounts which are marked with an incoming edge of class BadBehaviorInForum:

    DELETE VERTEX Account Where in.@Class = 'BadBehaviorInForum'

Deletes all those EmailMessages which are marked as spam by isSpam property

    DELETE VERTEX EMailMessage Where isSpam = true

Deletes every vertex of class 'Attachment', which has an edge towards it of class 'HasAttachment', with a property 'date' of condition to be all (HasAttachment edges) which are older than 1990, and secondly, the vertex 'Email' which is connected to class Attachment has a condition on its property 'from' to be 'some...@example.com':

    DELETE VERTEX Attachment Where in[@Class = 'HasAttachment'].date <= "1990" and in.out[@Class = "Email"].from = 'some...@example.com'