Clauses

The Cypher language enables users to perform standard database operations by using the following clauses:

• ALTER - alter existing definitions of enums
• CALL - calls a subquery inside the query
• CASE - allows the creation of conditional expressions
• CREATE - creates new nodes and relationships
• DELETE - deletes nodes and relationships
• DROP - drop all constraints, indexes, or the entire database
• EXPLAIN - inspect a particular Cypher query in order to see its execution plan.
• FOREACH - iterates over a list of elements and stores each element inside a variable
• LOAD CSV - loads data from CSV file
• MATCH - searches for patterns
• MERGE - creates patterns if they don’t exist
• OPTIONAL MATCH - behaves the same as MATCH, but when it fails to find the pattern it fills missing parts of the pattern with null values
• PROFILE - profiles the execution of a query returns a detailed report on how the query’s plan behaved
• REMOVE - removes labels and properties
• RETURN - defines what will be presented to the user in the result set
• SET - adds new or updates existing labels and properties
• UNION and UNION ALL - combines results from multiple queries
• UNWIND - unwinds a list of values as individual rows
• WHERE - filters the matched data
• WITH - combines multiple reads and writes
• USING PERIODIC COMMIT num_rows - batches query for periodic execution
• CALL {subquery} IN TRANSACTIONS OF num_rows ROWS - batches subquery for periodic execution