Skip to content
ScopeDBDocs
GuidesScopeQLAPI referenceRelease notes
Sign inStart free
ScopeDBDocs
Sign inStart free
  • Overview
  • Data model

    • Data types
    • Date and time
    • Semi-structured
    • Conversion
    • Computed columns
  • Commands

    • Overview
    • Query syntax
    • Query operators
      • Overview
      • Arithmetic
      • Comparison
      • Logical
      • Set operators
    • DDL
      • Overview
      • CREATE DATABASE
      • DROP DATABASE
      • CREATE SCHEMA
      • DROP SCHEMA
      • CREATE TABLE
      • DROP TABLE
      • ALTER TABLE
      • CREATE VIEW
      • DROP VIEW
      • SHOW TABLES
      • DESCRIBE TABLE
      • CREATE INDEX
      • DROP INDEX
    • DML
      • Overview
      • INSERT
      • DELETE
      • UPDATE
  • Functions

    • Overview
    • Aggregate
      • Overview
      • approx_count_distinct
      • approx_quantile
      • array_agg
      • avg
      • count
      • count_distinct
      • first, first_value
      • last, last_value
      • max
      • max_by
      • min
      • min_by
      • mode
      • object_agg
      • quantile
      • schema
      • stddev_pop
      • stddev_samp
      • sum
      • variance_pop
      • variance_samp
    • Conditional expression
      • Overview
      • IS [ NOT ]
    • Conversion
    • Date and time
      • Overview
      • ceil, floor
      • strftime, strptime
      • now
      • trunc
    • Numeric
      • Overview
      • abs
      • ceil
      • floor
      • ln, log
      • round
      • trunc
    • String
      • Overview
      • || (string concatenation)
      • contains
      • ends_with
      • length
      • lpad, rpad
      • ltrim
      • lower
      • md5
      • regexp_extract, regexp_extract_all
      • regexp_like
      • regexp_replace
      • repeat
      • replace
      • reverse
      • rtrim
      • search
      • search_ip
      • split
      • starts_with
      • String slicing
      • tokenize
      • trim
      • upper
    • Semi-structured data
      • Overview
      • {} (object construction)
      • [] (array construction)
      • [] (element access)
      • Array slicing
      • || (arrays and objects)
      • append
      • contains
      • dedup
      • exclude
      • keys
      • length
      • parse_json
      • to_json
      • typeof
    • Window
      • Overview
      • lag, lead
      • row_number
    • System
      • Overview
      • version
  1. ScopeQL

Commands

On this page
  • Queries
  • DDL statements
  • DML statements

ScopeQL commands query data, manage database objects, and modify table data.

Queries

  • Query syntax: structure of ScopeDB queries.
  • Query operators: arithmetic, logical, and other types of operators.

DDL statements

Data Definition Language (DDL) statements define and manage database objects.

DML statements

Data Manipulation Language (DML) statements change the data stored in tables.

On this page

  • Queries
  • DDL statements
  • DML statements
ScopeDB

Build

ScopeDB CloudPricingDocsGitHub

Explore

BlogBrand kitComponent library

Connect

CommunityContact usFeedback

© 2024–2026 ScopeDB. All rights reserved.