• Introduction
  • Getting Started
    • Installation
    • Run the server
    • Run the console
    • Run the Studio
    • Classes
    • Clusters
    • Record ID
    • Relationships
    • Basic SQL
    • Working with Graphs
    • Using Schema with Graphs
    • Setup a Distributed Database
    • Working with Distributed Graphs
  • Data Modeling
    • Basic Concepts
      • Supported Types
      • Inheritance
      • Concurrency
      • Schema
      • Graph or Document API?
      • Cluster Selection
      • Managing Dates
    • Graph Consistency
    • Fetching Strategies
    • Use Cases
      • Time Series
      • Chat
      • Key Value
      • Queue system
  • Administration
    • Console
      • Backup
      • Begin
      • Browse Class
      • Browse Cluster
      • List Classes
      • Cluster Status
      • List Clusters
      • List Servers
      • List Server Users
      • Check Database
      • 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
      • Load Script
      • Profiler
      • Properties
      • Release DB
      • Reload Record
      • Repair Database
      • 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
        • Neo4j to OrientDB Importer
          • Tutorial: Importing the northwind Database from Neo4j
        • Import from Neo4j using GraphML
          • Tutorial: Importing the movie Database from Neo4j
    • ETL
      • Configuration
      • Blocks
      • Sources
      • Extractors
      • Transformers
      • Loaders
      • Tutorial: Importing the Open Beer Database into OrientDB
      • 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
      • Data Centers
      • Query Profiler
      • Studio Auditing
      • Studio Backup Management
      • Teleporter
      • Neo4j to OrientDB Importer
    • 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
      • Import Configuration
    • Troubleshooting
      • Java
      • Query Examples
    • Performance Tuning
      • Setting Configuration
      • Graph API
      • Document API
      • Object API
      • Profiler
      • Leak Detector
      • Distributed tuning
    • Security
      • Database security
      • Server security
      • Database encryption
      • Secure SSL connections
      • Security Configuration
      • Kerberos Example
      • Security v2.2 Code Changes
      • Security v2.2 New Features
      • Symmetric Key Authentication
    • Server Management
      • Install as Service on Unix
      • Install as Service on Windows
      • Install with Docker
    • Stress Test Tool
  • APIs and Drivers
    • Functions
      • Creation
      • Usage
      • Accessing the Database
      • Server
        • exists()
        • flush()
        • getArgument()
        • getArguments()
        • getCharacterSet()
        • getContent()
        • getContentType()
        • getIfMatch()
        • getHeader()
        • getHttpMethod()
        • getHttpVersion()
        • getParameter()
        • getParameters()
        • getSessionId()
        • getURL()
        • getUser()
        • hasParameters()
        • isMultipart()
        • send()
        • sendStream()
        • setCharacterSet()
        • setContentType()
        • setHeader()
        • writeContent()
        • writeHeaders()
        • writeLine()
        • writeRecord()
        • writeRecords()
        • writeStatus()
      • Database
        • addEdge()
        • addVertex()
        • begin()
        • browseClass()
        • browseCluster()
        • close()
        • command()
        • commit()
        • countClass()
        • countEdges()
        • countVertices()
        • createEdgeType()
        • createVertexType()
        • delete()
        • dropCluster()
        • dropEdgeType()
        • dropVertexType()
        • getClusterIdByName()
        • getClusterNameById()
        • getClusterNames()
        • getClusterRecordSizeById()
        • getClusterRecordSizeByName()
        • getClusters()
        • getEdge()
        • getEdgeBaseType()
        • getEdgeType()
        • getUser()
        • getVertex()
        • getVertexBaseType()
        • getVertexType()
        • isAutoStartTx()
        • isUseLightweightEdges()
        • load()
        • open()
        • query()
        • removeEdge()
        • removeVertex()
        • rollback()
        • setUser()
        • setAuotStartTx()
        • setUseLightweightEdges()
    • Available Plugins and Tools
    • Java API
      • Java API Introduction
      • Graph API
        • Vertices and Edges
        • Blueprints Extension
        • Factory
        • Schema
          • Class
          • Property
        • Partitioned
        • Comparison
        • Lightweight Edges
        • Graph Batch Insert
      • 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
    • OrientJS (Node.js)
      • Server API
      • Database API
      • Record API
      • Class API
        • Class
        • Property
        • Records
      • Index API
      • Function API
      • Queries
        • create()
        • delete()
        • fetch()
        • insert()
        • liveQuery()
        • select()
        • transform()
        • traverse()
        • update()
      • Transactions
      • Events
    • PyOrient
      • Client
        • command()
        • batch()
        • data_cluster_add()
        • data_cluster_count()
        • data_cluster_data_range()
        • data_cluster_drop()
        • db_count_records()
        • db_create()
        • db_drop()
        • db_exists()
        • db_list()
        • db_open()
        • db_reload()
        • db_size()
        • get_session_token()
        • query()
        • query_async()
        • record_create()
        • record_delete()
        • record_load()
        • record_update()
        • set_session_token()
        • tx_commit()
          • attach()
          • begin()
          • commit()
          • rollback()
      • OGM
        • Connection
        • Schemas
        • Brokers
        • Batch
        • Scripts
    • C#/.NET
      • Server
        • ConfigGet()
        • ConfigList()
        • ConfigSet()
        • CreateDatabase()
        • DatabaseExists()
        • Databases()
        • DropDatabase()
      • Database
        • Clusters()
        • Command()
        • GetClusterIdFor()
        • GetClusterNameFor()
        • GetClusters()
        • Gremlin()
        • Insert()
        • JavaScript()
        • Query()
        • Select()
        • SqlBatch()
        • Update()
      • Query
        • Conditionals
        • Limiters
        • Sort
      • Transaction
        • Add()
        • AddEdge()
        • AddOrUpdate()
        • Delete()
        • GetPendingObject()
        • Update()
    • PHP
      • Client
      • Server
        • dbCreate()
        • dbDrop()
        • dbExists()
        • dbList()
      • Database
        • command()
        • dataClusterAdd()
        • dataClusterCount()
        • dataClusterDrop()
        • dataClusterDataRange()
        • dbCountRecords()
        • dbReload()
        • dbSize()
        • query()
        • queryAsync()
        • recordCreate()
        • recordLoad()
        • recordUpdate()
        • sqlBatch()
      • ClusterMap
        • dropClusterID()
        • getClusterID()
        • getIdList()
      • Record
        • getOClass()
        • getOData()
        • getRid()
        • jsonSerialize()
        • recordSerialize()
        • setOClass()
        • setOData()
        • setRid()
      • ID
      • Transaction
        • attach()
        • begin()
        • commit()
        • rollback()
    • Elixir
      • Server
        • create_db()
        • db_exists?()
        • distrib-config()
        • drop_db()
      • Database
        • command()
        • create_record()
        • db_countrecords()
        • db_reload()
        • db_size()
        • delete_record()
        • live_query()
        • live_query_unsubscribe()
        • load_record()
        • script()
        • update_record()
      • Types
      • Structs
        • BinaryRecord
        • Date
        • DateTime
        • Document
        • FetchPlan
        • RID
    • Scala API
    • HTTP API
    • Binary Protocol
      • CSV Serialization
      • Schemaless Serialization
      • Commands
  • SQL Reference
    • 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
      • 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
      • HA Set
      • Insert
      • Live Select
      • Live Unsubscribe
      • Match
      • Move Vertex
      • Optimize Database
      • Rebuild Index
      • Revoke
      • Select
      • Traverse
      • Truncate Class
      • Truncate Cluster
      • Truncate Record
      • Update
      • Update Edge
    • Filtering
    • Functions
    • Methods
    • Batch
    • Pagination
    • Sequences and auto increment
    • Pivoting with Query
    • Command Cache
    • Query Optimization
  • Indexing
    • SB-Tree
    • Hash
    • Auto-Sharding
    • Full Text
    • Lucene Full Text
    • Lucene Spatial Index
  • Scaling
    • Lifecycle
    • Configuration
      • Server Manager
      • Runtime Configuration
    • Replication
    • Sharding
    • Data Centers
    • Tuning
    • HA SQL Commands
      • HA Remove Server
      • HA Status
      • HA Sync Cluster
      • HA Sync Database
      • HA Set
  • 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
      • Server Status
      • Embed the Server
      • Web Server
    • System Database
    • System Users
      • Implementation
    • Multi Tenant
    • Plugins
      • Automatic Backup
      • SysLog
      • Mail
      • JMX
      • Rexster
      • Gephi Graph Render
      • spider-box
      • Script Interpreter Plugin
  • Contribute to OrientDB
    • Hackaton
    • Report an issue
      • Get in touch
      • More Tutorials
    • Presentations
      • Roadmap
  • Enterprise Edition
    • Auditing
  • Tutorials
    • Tutorial: Importing the Open Beer Database into OrientDB
    • Tutorial: Importing the movie Database from Neo4j
    • Tutorial: Importing the northwind Database from Neo4j
    • Java Hook Tutorial
  • Release Notes
  • 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 HA SET
CREATE SEQUENCE GRANT
ALTER SEQUENCE REVOKE
DROP SEQUENCE

results matching ""

    No results matching ""