• Introduction
  • Getting Started
    • Installation
      • Install as Service on Unix
      • Install as Service on Windows
      • Install with Docker
    • Run the server
    • Run the console
    • Run the Studio
  • Data Modeling
    • Graph or Document API?
    • Basic Concepts
      • Supported Types
      • Inheritance
      • Concurrency
      • Schema
      • Cluster Selection
      • Managing Dates
    • Classes
    • Clusters
    • Record ID
    • Relationships
    • Working with Graphs
    • Using Schema with Graphs
    • Graph Consistency
    • Fetching Strategies
    • Use Cases
      • Time Series
      • Chat
      • Key Value
      • Queue system
  • Administration
    • Console Command Reference
      • Backup
      • Begin
      • Browse Class
      • Browse Cluster
      • List Classes
      • Cluster Status
      • List Clusters
      • List Servers
      • List Server Users
      • Commit
      • Config
      • Config Get
      • Config Set
      • Connect
      • Create Cluster
      • Create Database
      • Create Index
      • Create Link
      • Create Property
      • Declare Intent
      • Delete
      • Dictionary Get
      • Dictionary Keys
      • Dictionary Put
      • Dictionary Remove
      • Disconnect
      • Display Record
      • Display Raw Record
      • Drop Cluster
      • Drop Database
      • Drop Server User
      • Export Database
      • Export Record
      • Freeze DB
      • Get
      • Gremlin
      • Import Database
      • Indexes
      • Info
      • Info Class
      • Info Property
      • Insert
      • Js
      • Jss
      • List Databases
      • List Connections
      • Load Record
      • Profiler
      • Properties
      • Release DB
      • Reload Record
      • Restore
      • Rollback
      • Set
      • Set Server User
      • Sleep
    • Upgrading
      • Backward compatibility
      • From 2.1.x to 2.2.x
      • From 2.0.x to 2.1.x
      • From 1.7.x to 2.0.x
      • From 1.6.x to 1.7.x
      • From 1.5.x to 1.6.x
      • From 1.4.x to 1.5.x
      • From 1.3.x to 1.4.x
    • Backup and Restore
      • Incremental Backup and Restore
    • Export and Import
      • Export format
      • Import From RDBMS
        • To Document Model
        • To Graph Model
      • Import From Neo4j
    • ETL
      • Configuration
      • Blocks
      • Sources
      • Extractors
      • Transformers
      • Loaders
      • Import the database of Beers
      • Import from CSV to a Graph
      • Import a tree structure
      • Import from JSON
      • Import from RDBMS
      • Import from DB-Pedia
      • Import from Parse (Facebook)
    • Logging
    • Scheduler
    • Studio
      • Query
      • Edit Document
      • Edit Vertex
      • Schema
      • Class
      • Graph Editor
      • Functions
      • Security
      • Database Management
      • Dashboard
      • Server Management
      • Cluster Management
      • Query Profiler
      • Studio Auditing
      • Teleporter
    • Teleporter
      • Installation and configuration
      • Execution strategies
      • Sequential executions and One-Way Synchronizer
      • Import filters
      • Inheritance
        • Single Table Inheritance
        • Table Per Class Inheritance
        • Table Per Concrete Class Inheritance
    • Troubleshooting
      • Java
      • Query Examples
    • Performance Tuning
      • Setting Configuration
      • Graph API
      • Document API
      • Object API
      • Profiler
      • Distributed tuning
    • Security
      • Database security
      • Server security
      • Database encryption
      • Secure SSL connections
    • Server Management
  • APIs and Drivers
    • Functions
      • Creating Functions
      • Using Functions
      • Accessing the Database
      • Server-side Functions
    • Available Plugins and Tools
    • Java API
      • Java API Introduction
      • Graph API
        • Vertices and Edges
        • Blueprints Extension
        • Factory
        • Schema
          • Class
          • Property
        • Partitioned
        • Comparison
        • Lightweight Edges
      • Document API
        • Database
        • Documents
        • Schema
          • Classes
          • Property
        • Field Part
        • Comparison
      • Object API
        • Binding
      • Traverse
      • Live Query
      • Multi-Threading
      • Transactions
      • Binary Data
      • Web Apps
      • JDBC Driver
      • JPA
    • JMX
    • Gremlin API
    • Javascript
      • Javascript API
    • Scala API
    • HTTP API
    • Binary Protocol
      • CSV Serialization
      • Schemaless Serialization
      • Commands
  • SQL Reference
    • CRUD Operations
      • Select
      • Insert
      • Update
      • Delete
      • Match
    • Commands
      • Alter Class
      • Alter Cluster
      • Alter Database
      • Alter Property
      • Alter Sequence
      • Create Class
      • Create Cluster
      • Create Edge
      • Create Function
      • Create Index
      • Create Link
      • Create Property
      • Create Sequence
      • Create User
      • Create Vertex
      • Delete Edge
      • Delete Vertex
      • Drop Class
      • Drop Cluster
      • Drop Index
      • Drop Property
      • Drop Sequence
      • Drop User
      • Explain
      • Find References
      • Grant
      • HA Remove Server
      • HA Status
      • HA Sync Cluster
      • HA Sync Database
      • Move Vertex
      • Optimize Database
      • Rebuild Index
      • Revoke
      • Traverse
      • Truncate Class
      • Truncate Cluster
      • Truncate Record
      • Update edge
    • Filtering
    • Functions
    • Methods
    • Batch
    • Pagination
    • Sequences and auto increment
    • Pivoting with Query
    • Command Cache
  • Indexing
    • SB-Tree
    • Hash
    • Full Text
    • Lucene Full Text
    • Lucene Spatial Index
      • Lucene Spatial Module
  • Scaling
    • Setup a Distributed Database
    • Working with Distributed Graphs
    • Lifecycle
    • Configuration
      • Server Manager
      • Runtime Configuration
    • Replication
    • Sharding
    • Tuning
    • HA SQL Commands
      • HA Remove Server
      • HA Sync Cluster
      • HA Sync Database
  • Internals
    • Storages
      • Memory storage
      • PLocal storage
        • Engine
        • Disk-Cache
        • WAL (Journal)
      • Local storage (deprecated)
    • Clusters
    • Limits
    • RidBag
    • SQL Syntax
    • Custom Index Engine
    • Caching
    • Transaction
    • Hooks - Triggers
    • Dynamic Hooks
      • Java (Native) Hooks
      • Java Hook Tutorial
    • Server
      • Embed the Server
      • Web Server
    • Plugins
      • Automatic Backup
      • Mail
      • JMX
      • Rexster
      • Gephi Graph Render
      • spider-box
  • Contribute to OrientDB
    • Hackaton
    • Report an issue
      • Get in touch
      • More Tutorials
    • Presentations
      • Roadmap
  • Enterprise Edition
    • Auditing
  • Published with GitBook

Commands

SQL Commands

CRUD Graph Schema & Indexes Database Utility
SELECT CREATE VERTEX CREATE CLASS CREATE CLUSTER CREATE LINK
INSERT CREATE EDGE ALTER CLASS ALTER CLUSTER FIND REFERENCES
UPDATE DELETE VERTEX DROP CLASS DROP CLUSTER EXPLAIN
DELETE DELETE EDGE CREATE PROPERTY ALTER DATABASE CREATE FUNCTION
TRAVERSE UPDATE EDGE ALTER PROPERTY CREATE DATABASE (console only) HA STATUS
TRUNCATE CLASS MATCH DROP PROPERTY DROP DATABASE (console only) HA REMOVE SERVER
TRUNCATE CLUSTER CREATE INDEX OPTIMIZE DATABASE HA SYNC DATABASE
TRUNCATE RECORD REBUILD INDEX CREATE USER HA SYNC CLUSTER
DROP INDEX DROP USER
CREATE SEQUENCE GRANT
ALTER SEQUENCE REVOKE
DROP SEQUENCE

results matching ""

    No results matching ""