SQL

SQL

Althought OrientDB is a NoSQL dbms, it supports SQL as language to execute queries and commands. The choice was made for the main reason that developers already know SQL and they feel more comfortable if start to use something familiar.

Many SQL commands share the WHERE conditions. In these examples the SQL keyworks are in uppercase but OrientDB ignore the case when parses.

Bear in mind that field names are case-sensitive. If you have a class !MyClass with a field named 'id', than sql statement SELECT FROM MyClass WHERE ID = 1 will always return an empty result set. For the class names, case sensitivity doesn't hold so you can write them in any register.

• SQL expression syntax - Operators - Functions
• Select used as command and for queries
• Traverse to cross records by relationships
• Insert to insert new records
• Update to update one or more records
• Delete to delete one or more records
• Create Vertex and Create Edge to work with graphs
• Truncate Class, Truncate Cluster, Truncate Record
• Grant and Revoke
• Create Class, Alter Class, Drop Class, Create Property, Alter Property, Drop Property
• Create Index, Rebuild Index, Drop Index
• Create Link
• Find References
• Alter Database, Alter Cluster
• Pagination
• Syntax