OrientDB Manual 1.7.8

SQL - DELETE VERTEX

This 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.

History and Compatibility

  • 1.1: first version
  • starting from v.1.4 the command uses the Blueprints API under the hood, so if you're working in Java using the OGraphDatabase API you could experience in some difference how edges are managed. To force the command to work with the "old" API change the GraphDB settings described in Graph backward compatibility

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[email protected] = '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 '[email protected]':

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