• Home
  • FIRST STEPS
  • Introduction
    • About This Manual
    • Overview of OrientDB
      • Editions
    • Release 3.0
      • What's new in OrientDB 3.0?
      • Available Packages
      • SQL Changes
      • API Changes
      • Known Issues
      • Upgrading to OrientDB 3.0
    • How to Report Bugs or Problems
    • How to Get in Touch with OrientDB
    • How to Contribute to OrientDB
    • OrientDB Roadmap
  • OrientDB in Five Minutes
    • Install
    • Create a DB
    • Create the Java Application
    • Connect to the DB and create the Schema
    • Create your First Graph and Run Queries
  • Getting Started
    • Installation
    • Run the server
    • Run the console
    • Run the Studio
    • Documents, Vertices and Edges
    • Classes, Schema and Constraints
    • Demo Database
      • Introduction
      • Data Model
      • Queries
        • Profiles
        • Friendship
        • Customers
        • Countries
        • Orders
        • Attractions
        • Services
        • Locations
        • Reviews
        • Recommendations
        • Business Opportunities
        • Polymorphism
        • Shortest Paths
        • Traverses
      • Graph Portions
    • Basic SQL
    • Users, Roles and Security
    • Distributed Architecture
    • Tutorials
      • Working with Graphs
      • Using Schema with Graphs
      • Setup a Distributed Database
      • Working with Distributed Graphs
      • Time Series
      • Chat
      • Key Value
      • Queue system
      • Import Tutorials
        • Importing the Open Beer Database into OrientDB
        • Importing the northwind Database from Neo4j
        • Importing the movie Database from Neo4j
  • General Information
    • Supported Types
    • Schema
    • Inheritance
    • Concurrency
    • Indexing
      • SB-Tree
      • Hash
      • Auto-Sharding
      • Full Text
      • Lucene Full Text
      • Lucene Spatial Index
    • Managing Dates
    • Transactions
    • Embedding the Server
    • Available OrientDB Plugins
      • Automatic Backup
      • SysLog
      • Mail
      • JMX
      • Rexster
      • Gephi Graph Render
      • spider-box
      • 3rd Party Plugins
  • Data Modeling
    • Multi Tenant
    • Basic Concepts
  • CORE TOPICS
  • OrientDB Programs
    • OrientDB Server-Startup Programs
      • server.sh
      • dserver.sh
      • Server Process
    • OrientDB Client Programs
      • Console
        • Console Modes
        • Console Commands
          • Backup
          • Browse Class
          • Browse Cluster
          • List Classes
          • Cluster Status
          • List Clusters
          • List Servers
          • List Server Users
          • Check Database
          • Config
          • Config Get
          • Config Set
          • Connect
          • Create Database
          • Declare Intent
          • Dictionary Get
          • Dictionary Keys
          • Dictionary Put
          • Dictionary Remove
          • Disconnect
          • Display Record
          • Display Raw Record
          • Drop Database
          • Drop Server User
          • Export Database
          • Export Record
          • Freeze DB
          • Get
          • Import Database
          • Indexes
          • Info
          • Info Class
          • Info Property
          • Js
          • Jss
          • List Databases
          • List Connections
          • Load Record
          • Load Script
          • Profiler
          • Properties
          • Release DB
          • Reload Record
          • Repair Database
          • Restore
          • Set
          • Set Server User
        • Custom Console Commands
    • OrientDB Administrative and Utility Programs
      • backup
      • shutdown
      • stresstester
    • OrientDB Data Import Programs
      • orientdb-neo4j-importer
      • oetl
  • OrientDB Server Administration
    • Installation
      • Prerequisites
      • Installation from Source
      • Install as Service on Unix
      • Install as Service on Windows
      • Install with Docker
    • Configuration
    • Upgrade
      • Backward Compatibility
      • Upgrading a Distributed Environment
    • Logs
    • Event Scheduler
    • Functions
      • Creating Functions
      • Using Functions
      • Accessing the Database
      • Server-side Functions
    • Backup and Restore
      • Incremental Backup and Restore
    • Export and Import
      • Export to & Import from JSON
        • Export format
      • Import From RDBMS
        • To Document Model
        • To Graph Model
      • Import From Neo4j
        • Import from Neo4j using GraphML
    • Monitoring
      • JMX
  • OrientDB Tools
    • Studio
      • Overview of Menus and Panels
      • Working with Databases
        • Common Database Operations
        • Database Management Panel
      • Working with Data
        • Browse Panel
          • Querying Data
          • Modifying Data
            • Edit Document
            • Edit Vertex
            • Edit Edge
        • Graph Editor
      • Working with Schemas
        • Schema Manager Panel
        • Classes
        • Properties
        • Indexes
      • Working with Functions
        • Functions Management Panel
      • Working with Users and Roles
        • Security Manager Panel
        • Users Management
        • Roles Management
      • Backups, Imports and Exports
        • Backup Management Panel
        • Integration with Teleporter
        • Integration with the Neo4j to OrientDB Importer
      • Server Management
        • Dashboard Panel
        • Servers Management Panel
        • Cluster Management Panel
          • Data Centers
        • Query Profiler Panel
        • Security Panel
          • Server Auditing
        • Alerts Management Panel
      • 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
    • ETL
      • Configuration
      • Blocks
      • Sources
      • Extractors
      • Transformers
      • Loaders
      • Import from CSV to a Graph
      • Import a tree structure
      • Import from JSON
      • Import from RDBMS
      • Import from DB-Pedia
      • Import from Parse (Facebook)
    • Neo4j to OrientDB Importer
  • SQL, API, DRIVERS
  • SQL Reference
    • Introduction
      • Querying Metadata
    • SQL Syntax
      • Projections
    • SQL 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
      • Profile
      • 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
  • APIs and Drivers
    • Java API
      • Java Multi-Model API
        • Database creation and connection
        • Manipulating data in Java
        • Running SQL statements Java
        • Defining Database Schema
          • Classes
          • Property
      • Reference
        • OClass
          • addCluster()
          • addClusterId()
          • addSuperClass()
          • count()
          • createIndex()
          • createProperty()
          • dropProperty()
          • existsProperty()
          • getAllSubclasses()
          • getAllSuperClasses()
          • getAutoShardingIndex()
          • getClassIndex()
          • getClassIndexes()
          • getClassInvolvedIndexes()
          • getClusterIds()
          • getDefaultClusterId()
          • getIndexedProperties()
          • getName()
          • getProperty()
          • getSubclasses()
          • getSuperClassesNames()
          • hasClusterId()
          • hasPolymorphicClusterId()
          • hasSuperClasses()
          • isEdgeType()
          • isVertexType()
          • properties()
          • propertiesMap()
          • removeClusterId()
          • removeSuperClass()
          • setDefaultClusterId()
          • setName()
          • truncate()
          • truncateCluster()
        • OCluster
          • close()
          • delete()
          • deleteRecord()
          • exists()
          • getFileName()
          • getFirstPosition()
          • getId()
          • getLastPosition()
          • getName()
          • getNextPosition()
          • getRecordSize()
          • getTombstonesCount()
          • hideRecord()
          • open()
          • truncate()
          • updateRecord()
        • ODatabaseDocument
          • addCluster()
          • begin()
          • browseClass()
          • browseCluster()
          • close()
          • command()
          • commit()
          • countClass()
          • countClusterElements()
          • createClass()
          • createClassIfNotExists()
          • createEdgeClass()
          • createVertexClass()
          • declareIntent()
          • delete()
          • dropCluster()
          • execute()
          • getActiveIntent()
          • getClass()
          • getClusterIdByName()
          • getClusterNameById()
          • getClusters()
          • getDefaultClusterId()
          • getMetadata()
          • getName()
          • getRecord()
          • getRecordType()
          • getTransaction()
          • getURL()
          • getUser()
          • incrementalBackup()
          • isActiveOnCurrentThread()
          • isClosed()
          • live()
          • load()
          • query()
          • registerListener()
          • newBlob()
          • newEdge()
          • newElement()
          • newInstance()
          • newVertex()
          • rollback()
          • save()
          • truncateCluster()
          • unregisterListener()
        • ODatabaseSession
        • ODatabaseListener
        • OEdge
          • getFrom()
          • getTo()
          • isLightweight()
        • OElement
          • asEdge()
          • asVertex()
          • getProperty()
          • getPropertyNames()
          • getSchemaType()
          • isEdge()
          • isVertex()
          • removeProperty()
          • setProperty()
        • OFunction
          • getCode()
          • getId()
          • getLanguage()
          • getName()
          • getParameters()
          • isIdempotent()
          • setCode()
          • setIdempotent()
          • setLanguage()
          • setName()
          • setParameeters()
        • OFunctionLibrary
          • createFunction()
          • dropFunction()
          • getFunction()
          • getFunctionNames()
        • OIntent
        • OLiveQueryMonitor
        • OLiveQueryResultListener
          • onCreate()
          • onDelete()
          • onEnd()
          • onError()
          • onUpdate()
        • OMetadata
          • getFunctionLibrary()
          • getSchema()
        • OProperty
          • getDefaultValue()
          • getLinkedClass()
          • getLinkedType()
          • getMax()
          • getMin()
          • getName()
          • getType()
          • isMandatory()
          • isNotNull()
          • isReadonly()
          • setDefaultValue()
          • setLinkedClass()
          • setLinkedType()
          • setMax()
          • setMin()
          • setName()
          • setType()
        • ORecordOperation
        • OResult
        • OResultSet
          • close()
          • edgeStream()
          • elementStream()
          • estimateSize()
          • hasNext()
          • next()
          • remove()
          • stream()
          • vertexStream()
        • ORID
        • OrientDB
          • create()
          • createIfNotExists()
          • drop()
          • exists()
          • list()
          • open()
        • ORule
        • OSchema
          • countClasses()
          • createAbstractClass()
          • createClass()
          • dropClass()
          • existsClass()
          • getClass()
          • getClassByClusterId()
          • getClasses()
          • getClassesRelyOnCluster()
          • getOrCreateClass()
        • OSecurityRole
          • addRule()
          • allow()
          • getDocument()
          • getName()
          • getParentRole()
          • getRuleSet()
          • grant()
          • hasRule()
          • revoke()
          • setParentRole()
        • OSecurityUser
          • addRole()
          • allow()
          • checkPassword()
          • getAccountStatus()
          • getDocument()
          • getName()
          • getPassword()
          • getRoles()
          • isRuleDefined()
          • hasRole()
          • removeRole()
          • setAccountStatus()
          • setName()
          • setPassword()
        • OServer
          • addTemporaryUser()
          • addUser()
          • authenticate()
          • dropUser()
          • existsStoragePath()
          • getAvailableStorageNames()
          • getConfiguration()
          • getDatabaseDirectory()
          • getInstance()
          • getInstanceByPath()
          • getStoragePath()
          • isActive()
          • isAllowed()
          • openDatabase()
          • restart()
          • saveConfiguration()
          • shutdown()
          • startup()
        • OTransaction
          • amountOfNestedTxs()
          • begin()
          • close()
          • commit()
          • getDatabase()
          • getEntryCount()
          • getInvolvedIndexes()
          • getIsolationLevel()
          • getNewRecordEntriesByClass()
          • getNewRecordEntriesByCluster()
          • getRecordEntry()
          • getRecordOperations()
          • getStatus()
          • hasRecordCreation()
          • rollback()
          • setIsolationLevel()
        • OType
        • OVertex
          • addEdge()
          • getEdges()
          • getVertices()
      • TinkerPop 2.6 Graph API
        • Tutorial
        • Vertices and Edges
        • Blueprints Extension
        • Factory
        • Schema
          • Class
          • Property
        • Partitioned
        • Lightweight Edges
        • Graph Batch Insert
      • Apache TinkerPop 3
      • Document API
        • Documents
      • Live Query
        • Live Query Intro
        • Live Query vs Traditional Query
        • Live Query in Java
      • Object API
        • Database
        • POJO
        • Attach
        • Schema
        • Binding
      • Traverse
      • Multi-Threading
        • Usage
        • Concurrency Control
      • Transactions
      • Fetching Strategies
      • Graph Consistency
      • Binary Data
      • JPA
    • JDBC Driver
    • Scala API
    • OrientJS Legacy - Node.js Driver
      • 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
    • OrientJS - Node.js Driver
      • Reference
        • Client API
          • Connecting
          • Databases Manipulation
          • Sessions Access
        • Session API
          • Query
          • Command
          • Batch Script
          • Transactions
          • Live Queries
          • Query Builder
    • PyOrient - Python Driver
      • 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
    • OrientDB-NET - C#/.NET Driver
      • 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()
    • PhpOrient - PHP Driver
      • 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()
    • MarcoPolo - Elixir Driver
      • 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
    • Javascript (legacy)
      • Javascript API
    • Rest API
    • Gremlin API
  • ADVANCED TOPICS
  • Security
    • OrientDB Security Guide
    • OrientDB Data Protection and Privacy
    • 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
  • Distributed Architecture
    • Lifecycle
    • Configuration
      • Server Manager
      • Runtime Configuration
    • Replication
    • Sharding
    • Data Centers
  • Troubleshooting
    • Java
    • Memory Leak Detector
    • Direct Memory Tracing
  • Performance Tuning
    • Tuning the Graph API
    • Tuning the Document API
    • Tuning the Object API
    • Profiler
    • Distributed Configuration Tuning
    • OrientDB Stress Test Tool
  • Enterprise Edition
    • Auditing
  • Internals
    • System database
    • Storages
      • Memory storage
      • PLocal storage
        • Engine
        • Disk-Cache
        • WAL (Journal)
      • Local storage (deprecated)
    • Clusters
    • Limits
    • RidBag
    • Custom Index Engine
    • Caching
    • Hooks - Triggers
      • Dynamic Hooks
      • Java (Native) Hooks
    • Server
      • Server Status
    • Web Server
    • Binary Protocol
      • CSV Serialization
      • Schemaless Serialization
      • Commands
  • Release Notes
  • Published with GitBook

SQL 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 MOVE VERTEX DROP PROPERTY DROP DATABASE (console only) HA REMOVE SERVER
TRUNCATE CLUSTER MATCH 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 PROFILE
ALTER SEQUENCE REVOKE
DROP SEQUENCE

results matching ""

    No results matching ""