CODEWITHSUNDEEP
neo4jcyphermemgraphdbopencypher
alexanoid
alexanoid

Reputation: 25812

DETACH DELETE Neo4j 2.3.x/Cypher

What is the behaviour and purpose of the new Cypher operator DETACH DELETE added in Neo4j 2.3.x?

Upvotes: 14

Views: 8360

Answers (2)

Brian Underwood
Brian Underwood

Reputation: 10856

If you want to delete nodes, you need to delete the relationships as well. In previous versions you would need to do:

MATCH (n)
OPTIONAL MATCH (n)-[r]-()
DELETE n, r

Now you can simply say:

MATCH (n)
DETACH DELETE n

Upvotes: 25

Arion Krause
Arion Krause

Reputation: 314

I could not comment on Brian's answer so here it is:

This command:

MATCH n
DETACH DELETE n

Gives to following error:

WARNING: Parentheses are required to identify nodes in patterns, i.e. (n) (line 1, column 7 (offset: 6))
"MATCH n"
       ^

Thus the correct command is:

MATCH (n)
DETACH DELETE n

Upvotes: 6

Related Questions