• Return to book
  • Review this book
  • About the author
  • Introduction
  • 1. Getting Started
    • 1.1. Document and Graph models
    • 1.2. Installation
    • 1.3. Run the server
    • 1.4. Run the console
    • 1.5. Classes
    • 1.6. Clusters
    • 1.7. Record ID
    • 1.8. SQL
    • 1.9. Relationships
    • 1.10. Working with Graphs
    • 1.11. Using Schema with Graphs
    • 1.12. Setup a Distributed Database
    • 1.13. Working with Distributed Graphs
    • 1.14. Java API
    • 1.15. More on Tutorials
      • 1.15.1. Presentations
  • 2. Basic Concepts
    • 2.1. Supported Types
    • 2.2. Inheritance
    • 2.3. Schema
  • 3. Fetching Strategies
  • 4. Indexes
    • 4.1. SB-Tree
    • 4.2. Hash
    • 4.3. Full Text
    • 4.4. Lucene Full Text
    • 4.5. Lucene Spatial
  • 5. Security
    • 5.1. SSL
  • 6. Caching
  • 7. Functions
  • 8. Transaction
  • 9. Hook - Triggers
    • 9.1. Dynamic Hooks
    • 9.2. Java (Native) Hooks
  • 10. API
    • 10.1. SQL
      • 10.1.1. Filtering
      • 10.1.2. Functions
      • 10.1.3. Methods
      • 10.1.4. Batch
      • 10.1.5. Pagination
      • 10.1.6. Commands
        • 10.1.6.1. Select
        • 10.1.6.2. Insert
        • 10.1.6.3. Update
        • 10.1.6.4. Delete
        • 10.1.6.5. Alter Class
        • 10.1.6.6. Alter Cluster
        • 10.1.6.7. Alter Database
        • 10.1.6.8. Alter Property
        • 10.1.6.9. Create Class
        • 10.1.6.10. Create Cluster
        • 10.1.6.11. Create Edge
        • 10.1.6.12. Create Function
        • 10.1.6.13. Create Index
        • 10.1.6.14. Create Link
        • 10.1.6.15. Create Property
        • 10.1.6.16. Create Vertex
        • 10.1.6.17. Move Vertex
        • 10.1.6.18. Delete Edge
        • 10.1.6.19. Delete Vertex
        • 10.1.6.20. Drop Class
        • 10.1.6.21. Drop Cluster
        • 10.1.6.22. Drop Index
        • 10.1.6.23. Drop Property
        • 10.1.6.24. Explain
        • 10.1.6.25. Find References
        • 10.1.6.26. Grant
        • 10.1.6.27. Rebuild Index
        • 10.1.6.28. Revoke
        • 10.1.6.29. Traverse
        • 10.1.6.30. Truncate Class
        • 10.1.6.31. Truncate Cluster
        • 10.1.6.32. Trucate Record
    • 10.2. Java API
      • 10.2.1. Graph API
        • 10.2.1.1. Factory
        • 10.2.1.2. Schema
        • 10.2.1.3. Partitioned
        • 10.2.1.4. Comparison
      • 10.2.2. Document API
        • 10.2.2.1. Schema
        • 10.2.2.2. Field Part
        • 10.2.2.3. Comparison
      • 10.2.3. Object API
        • 10.2.3.1. Binding
      • 10.2.4. Traverse
      • 10.2.5. Multi-Threading
      • 10.2.6. Transactions
      • 10.2.7. Binary Data
      • 10.2.8. Web Apps
      • 10.2.9. Server Management
      • 10.2.10. JDBC Driver
      • 10.2.11. JPA
    • 10.3. Gremlin API
    • 10.4. Javascript
      • 10.4.1. Javascript API
    • 10.5. Scala API
    • 10.6. HTTP API
    • 10.7. Binary Protocol
      • 10.7.1. CSV Serialization
      • 10.7.2. Schemaless Serialization
      • 10.7.3. Commands
  • 11. Use Cases
    • 11.1. Time Series
    • 11.2. Key Value
  • 12. Server
    • 12.1. Embed the Server
    • 12.2. Plugins
      • 12.2.1. Automatic Backup
      • 12.2.2. Mail
      • 12.2.3. JMX
  • 13. Studio
    • 13.1. Query
    • 13.2. Edit Document
    • 13.3. Edit Vertex
    • 13.4. Schema
    • 13.5. Class
    • 13.6. Graph Editor
    • 13.7. Functions
    • 13.8. Security
    • 13.9. Database Management
    • 13.10. Server Management
  • 14. Console
    • 14.1. Backup
    • 14.2. Begin
    • 14.3. Browse Class
    • 14.4. Browse Cluster
    • 14.5. Classes
    • 14.6. Clusters
    • 14.7. Commit
    • 14.8. Config
    • 14.9. Config Get
    • 14.10. Config Set
    • 14.11. Connect
    • 14.12. Create Cluster
    • 14.13. Create Database
    • 14.14. Create Index
    • 14.15. Create Link
    • 14.16. Create Property
    • 14.17. Declare Intent
    • 14.18. Delete
    • 14.19. Dictionary Get
    • 14.20. Dictionary Keys
    • 14.21. Dictionary Put
    • 14.22. Dictionary Remove
    • 14.23. Disconnect
    • 14.24. Display Record
    • 14.25. Drop Cluster
    • 14.26. Drop Database
    • 14.27. Export
    • 14.28. Export Record
    • 14.29. Freeze DB
    • 14.30. Get
    • 14.31. Grant
    • 14.32. Import
    • 14.33. Info
    • 14.34. Info Class
    • 14.35. Insert
    • 14.36. Load Record
    • 14.37. Profiler
    • 14.38. Properties
    • 14.39. Release DB
    • 14.40. Reload Record
    • 14.41. Restore
    • 14.42. Revoke
    • 14.43. Rollback
    • 14.44. Set
  • 15. Operations
    • 15.1. Installation
      • 15.1.1. Install with Docker
      • 15.1.2. Install as Service on Unix/Linux
      • 15.1.3. Install as Service on Windows
    • 15.2. Performance Tuning
      • 15.2.1. Setting Configuration
      • 15.2.2. Graph API
      • 15.2.3. Document API
      • 15.2.4. Object API
      • 15.2.5. Profiler
    • 15.3. ETL
      • 15.3.1. Configuration
      • 15.3.2. Blocks
      • 15.3.3. Sources
      • 15.3.4. Extractors
      • 15.3.5. Transformers
      • 15.3.6. Loaders
      • 15.3.7. Import from RDBMS
      • 15.3.8. Import from DB-Pedia
      • 15.3.9. Import from Parse (Facebook)
    • 15.4. Distributed Architecture
      • 15.4.1. Lifecycle
      • 15.4.2. Configuration
      • 15.4.3. Server Manager
      • 15.4.4. Replication
      • 15.4.5. Sharding
      • 15.4.6. Cache
    • 15.5. Backup and Restore
    • 15.6. Export and Import
      • 15.6.1. Export format
      • 15.6.2. Import From RDBMS
        • 15.6.2.1. To Document Model
        • 15.6.2.2. To Graph Model
      • 15.6.3. Import From Neo4j
    • 15.7. Logging
  • 16. Enterprise Edition
  • 17. Troubleshooting
    • 17.1. Java
  • 18. Available Plugins
    • 18.1. Rexster
    • 18.2. Gephi Graph Render
  • 19. Upgrade
    • 19.1. Backward compatibility
    • 19.2. From 1.7.x to 2.0.x
    • 19.3. From 1.6.x to 1.7.x
    • 19.4. From 1.5.x to 1.6.x
    • 19.5. From 1.4.x to 1.5.x
    • 19.6. From 1.3.x to 1.4.x
  • 20. Internals
    • 20.1. Storages
      • 20.1.1. Memory storage
      • 20.1.2. PLocal storage
        • 20.1.2.1. Engine
        • 20.1.2.2. Disk-Cache
        • 20.1.2.3. WAL (Journal)
      • 20.1.3. Local storage (deprecated)
    • 20.2. Clusters
    • 20.3. RidBag
    • 20.4. SQL Syntax
    • 20.5. Custom Index Engine
  • 21. Contribute to OrientDB
    • 21.1. The Team
    • 21.2. Hackaton
    • 21.3. Report an issue
  • 22. Get in touch
Powered by GitBook

OrientDB Manual

SQL Commands

CRUD Graph Schema Indexes Database Utility
Select Create Vertex Create Class Create Index Create Cluster Create Link
Insert Create Edge Alter Class Rebuild Index Alter Cluster Find References
Update Delete Vertex Drop Class Drop Index Drop Cluster Explain
Delete Delete Edge Create Property Alter Database Grant
Traverse Alter Property Create Database (console only) Revoke
Truncate Class Drop Property Drop Database (console only) Create function
Truncate Cluster
Truncate Record