OrientDB
  • Products
    • Why OrientDB?
    • OrientDB Enterprise
    • Studio
    • OrientDB vs Neo4j
    • OrientDB vs MongoDB
  • Subscriptions
  • Services
    • Consulting
    • Training
    • Support
  • Customer & Partners
    • Use Cases
    • Customers
    • Partners
  • Learn
    • Academy
    • Whitepapers
    • Presentation
    • Documentation
  • Download
  • About us
  • Blog
  • Community
  • News & Events
  • Careers
  • Contacts
  • Test
  • Introduction
  • 1. Getting Started
    • 1.1. Installation
      • 1.1.1. Install as Service on Unix
      • 1.1.2. Install as Service on Windows
      • 1.1.3. Install with Docker
    • 1.2. Run the server
    • 1.3. Run the console
    • 1.4. Run the Studio
  • 2. Data Modeling
    • 2.1. Graph or Document API?
    • 2.2. Basic Concepts
      • 2.2.1. Supported Types
      • 2.2.2. Inheritance
      • 2.2.3. Concurrency
      • 2.2.4. Schema
      • 2.2.5. Cluster Selection
      • 2.2.6. Managing Dates
    • 2.3. Classes
    • 2.4. Clusters
    • 2.5. Record ID
    • 2.6. Relationships
    • 2.7. Working with Graphs
    • 2.8. Using Schema with Graphs
    • 2.9. Graph Consistency
    • 2.10. Fetching Strategies
    • 2.11. Use Cases
      • 2.11.1. Time Series
      • 2.11.2. Chat
      • 2.11.3. Key Value
      • 2.11.4. Queue system
  • 3. Administration
    • 3.1. Console Command Reference
      • 3.1.1. Backup
      • 3.1.2. Begin
      • 3.1.3. Browse Class
      • 3.1.4. Browse Cluster
      • 3.1.5. List Classes
      • 3.1.6. Cluster Status
      • 3.1.7. List Clusters
      • 3.1.8. List Servers
      • 3.1.9. List Server Users
      • 3.1.10. Commit
      • 3.1.11. Config
      • 3.1.12. Config Get
      • 3.1.13. Config Set
      • 3.1.14. Connect
      • 3.1.15. Create Cluster
      • 3.1.16. Create Database
      • 3.1.17. Create Index
      • 3.1.18. Create Link
      • 3.1.19. Create Property
      • 3.1.20. Declare Intent
      • 3.1.21. Delete
      • 3.1.22. Dictionary Get
      • 3.1.23. Dictionary Keys
      • 3.1.24. Dictionary Put
      • 3.1.25. Dictionary Remove
      • 3.1.26. Disconnect
      • 3.1.27. Display Record
      • 3.1.28. Display Raw Record
      • 3.1.29. Drop Cluster
      • 3.1.30. Drop Database
      • 3.1.31. Drop Server User
      • 3.1.32. Export Database
      • 3.1.33. Export Record
      • 3.1.34. Freeze DB
      • 3.1.35. Get
      • 3.1.36. GREMLIN
      • 3.1.37. Import Database
      • 3.1.38. Indexes
      • 3.1.39. Info
      • 3.1.40. Info Class
      • 3.1.41. Info Property
      • 3.1.42. Insert
      • 3.1.43. List Databases
      • 3.1.44. List Connections
      • 3.1.45. Load Record
      • 3.1.46. Profiler
      • 3.1.47. Properties
      • 3.1.48. Release DB
      • 3.1.49. Reload Record
      • 3.1.50. Restore
      • 3.1.51. Rollback
      • 3.1.52. Set
      • 3.1.53. Set Server User
      • 3.1.54. Sleep
    • 3.2. Upgrading
      • 3.2.1. Backward compatibility
      • 3.2.2. From 2.0.x to 2.1.x
      • 3.2.3. From 1.7.x to 2.0.x
      • 3.2.4. From 1.6.x to 1.7.x
      • 3.2.5. From 1.5.x to 1.6.x
      • 3.2.6. From 1.4.x to 1.5.x
      • 3.2.7. From 1.3.x to 1.4.x
    • 3.3. Backup and Restore
      • 3.3.1. Automatic Backup Plugin
    • 3.4. Export and Import
      • 3.4.1. Export format
      • 3.4.2. Import From RDBMS
        • 3.4.2.1. To Document Model
        • 3.4.2.2. To Graph Model
      • 3.4.3. Import From Neo4j
    • 3.5. ETL
      • 3.5.1. Configuration
      • 3.5.2. Blocks
      • 3.5.3. Sources
      • 3.5.4. Extractors
      • 3.5.5. Transformers
      • 3.5.6. Loaders
      • 3.5.7. Import the database of Beers
      • 3.5.8. Import from CSV to a Graph
      • 3.5.9. Import a tree structure
      • 3.5.10. Import from JSON
      • 3.5.11. Import from RDBMS
      • 3.5.12. Import from DB-Pedia
      • 3.5.13. Import from Parse (Facebook)
    • 3.6. Logging
    • 3.7. Studio
      • 3.7.1. Query
      • 3.7.2. Edit Document
      • 3.7.3. Edit Vertex
      • 3.7.4. Schema
      • 3.7.5. Class
      • 3.7.6. Graph Editor
      • 3.7.7. Functions
      • 3.7.8. Security
      • 3.7.9. Database Management
      • 3.7.10. Server Management
      • 3.7.11. Auditing
    • 3.8. Troubleshooting
      • 3.8.1. Java
      • 3.8.2. Query Examples
    • 3.9. Performance Tuning
      • 3.9.1. Setting Configuration
      • 3.9.2. Graph API
      • 3.9.3. Document API
      • 3.9.4. Object API
      • 3.9.5. Profiler
      • 3.9.6. Distributed tuning
    • 3.10. Security
      • 3.10.1. Database security
      • 3.10.2. Server security
      • 3.10.3. Database encryption
      • 3.10.4. Secure SSL connections
      • 3.10.5. Web Server
    • 3.11. Server Management
  • 4. APIs and Drivers
    • 4.1. Available Plugins and Tools
    • 4.2. Java API
      • 4.2.1. Java API Introduction
      • 4.2.2. Graph API
        • 4.2.2.1. Factory
        • 4.2.2.2. Schema
        • 4.2.2.3. Partitioned
        • 4.2.2.4. Comparison
        • 4.2.2.5. Lightweight Edges
      • 4.2.3. Document API
        • 4.2.3.1. Schema
        • 4.2.3.2. Field Part
        • 4.2.3.3. Comparison
      • 4.2.4. Object API
        • 4.2.4.1. Binding
      • 4.2.5. Traverse
      • 4.2.6. Live Query
      • 4.2.7. Multi-Threading
      • 4.2.8. Transactions
      • 4.2.9. Binary Data
      • 4.2.10. Web Apps
      • 4.2.11. JDBC Driver
      • 4.2.12. JPA
    • 4.3. JMX
    • 4.4. Gremlin API
    • 4.5. Javascript
      • 4.5.1. Javascript API
    • 4.6. Scala API
    • 4.7. HTTP API
    • 4.8. Binary Protocol
      • 4.8.1. CSV Serialization
      • 4.8.2. Schemaless Serialization
      • 4.8.3. Commands
  • 5. SQL Reference
    • 5.1. CRUD Operations
      • 5.1.1. Select
      • 5.1.2. Insert
      • 5.1.3. Update
      • 5.1.4. Delete
    • 5.2. Commands
      • 5.2.1. Alter Class
      • 5.2.2. Alter Cluster
      • 5.2.3. Alter Database
      • 5.2.4. Alter Property
      • 5.2.5. Alter Sequence
      • 5.2.6. Create Class
      • 5.2.7. Create Cluster
      • 5.2.8. Create Edge
      • 5.2.9. Create Function
      • 5.2.10. Create Index
      • 5.2.11. Create Link
      • 5.2.12. Create Property
      • 5.2.13. Create Sequence
      • 5.2.14. Create User
      • 5.2.15. Create Vertex
      • 5.2.16. Move Vertex
      • 5.2.17. Update edge
      • 5.2.18. Delete Edge
      • 5.2.19. Delete Vertex
      • 5.2.20. Drop Class
      • 5.2.21. Drop Cluster
      • 5.2.22. Drop Index
      • 5.2.23. Drop Property
      • 5.2.24. Drop Sequence
      • 5.2.25. Drop User
      • 5.2.26. Explain
      • 5.2.27. Find References
      • 5.2.28. Grant
      • 5.2.29. Optimize Database
      • 5.2.30. Rebuild Index
      • 5.2.31. Revoke
      • 5.2.32. Traverse
      • 5.2.33. Truncate Class
      • 5.2.34. Truncate Cluster
      • 5.2.35. Truncate Record
    • 5.3. Filtering
    • 5.4. Functions
    • 5.5. Methods
    • 5.6. Batch
    • 5.7. Pagination
    • 5.8. Sequences and auto increment
    • 5.9. Pivoting with Query
    • 5.10. Command Cache
  • 6. Indexing
    • 6.1. SB-Tree
    • 6.2. Hash
    • 6.3. Full Text
    • 6.4. Lucene Full Text
    • 6.5. Lucene Spatial Index
      • 6.5.1. Lucene Spatial Module
  • 7. Scaling
    • 7.1. Working with Distributed Graphs
    • 7.2. Lifecycle
    • 7.3. Configuration
      • 7.3.1. Runtime Configuration
    • 7.4. Server Manager
    • 7.5. Replication
    • 7.6. Sharding
    • 7.7. Cache
    • 7.8. Setup a Distributed Database
  • 8. Internals
    • 8.1. Storages
      • 8.1.1. Memory storage
      • 8.1.2. PLocal storage
        • 8.1.2.1. Engine
        • 8.1.2.2. Disk-Cache
        • 8.1.2.3. WAL (Journal)
      • 8.1.3. Local storage (deprecated)
    • 8.2. Clusters
    • 8.3. Limits
    • 8.4. RidBag
    • 8.5. SQL Syntax
    • 8.6. Custom Index Engine
    • 8.7. Caching
    • 8.8. Functions
    • 8.9. Transaction
    • 8.10. Hooks - Triggers
    • 8.11. Dynamic Hooks
      • 8.11.1. Java (Native) Hooks
      • 8.11.2. Java Hook Tutorial
    • 8.12. Server
      • 8.12.1. Embed the Server
    • 8.13. Plugins
      • 8.13.1. Mail
      • 8.13.2. JMX
      • 8.13.3. Rexster
      • 8.13.4. Gephi Graph Render
      • 8.13.5. spider-box
  • 9. Contribute to OrientDB
    • 9.1. The Team
      • 9.1.1. Hackaton
      • 9.1.2. Report an issue
    • 9.2. Get in touch
    • 9.3. More Tutorials
      • 9.3.1. Presentations
    • 9.4. Roadmap
  • 10. Enterprise Edition
    • 10.1. Auditing
Powered by GitBook

Test

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 OPTIMIZE DATABASE
TRUNCATE RECORD
  • Legal stuff
  • Privacy policy

© 2015 OrientDB OrientDB is a registered trademark. All rights reserved.