SQL Reference

Data Definition Language (DDL) Command Reference

DDL statements allow users to run commands and administrative operations on the System. You can execute DDL commands over a database connection to manage nodes, storage spaces, tables and views, system configuration, users and groups, underlying storage segments, and more.

Quoting Identifiers: In all DDL statements, identifiers not in double quotes must begin with a letter and can only contain letters, numbers, and underscores. Identifiers are the names of databases, tables, nodes, etc. For details, see Identifiers. The Ocient System internally converts identifiers to lower-case. Identifiers in double quotes can contain any characters besides newline and carriage return, can begin with any character, and are not case-adjusted. To use an identifier with the same name as any keyword, it must be in double quotes.

String literals must be enclosed in single quotes. A single quote within a string can be escaped as ". A string literal can be preceded by e to enable additional escape sequences (ex: e'\n').

DDL Commands are supported for the following categories:

Cluster and Node Management

  • CLUSTER
    • CREATE CLUSTER
    • DROP CLUSTER
    • ALTER CLUSTER
      • ALTER CLUSTER ADD PARTICIPANTS
      • ALTER CLUSTER DROP PARTICIPANTS
      • ALTER CLUSTER ALTER CONFIG SET
      • ALTER CLUSTER RENAME
  • STORAGESPACE
    • CREATE STORAGESPACE
    • DROP STORAGESPACE
    • ALTER STORAGESPACE RENAME
  • NODE
    • DROP NODE
    • ALTER NODE
      • ALTER NODE ADD ROLE
      • ALTER NODE REMOVE ROLE
      • ALTER NODE ALTER CONFIG SET
      • ALTER NODE RENAME
      • ALTER NODE ALTER LOG LEVEL SET
      • ALTER NODE ALTER METRIC LEVEL
      • ALTER NODE SET ADDRESS
  • CONNECTIVITY POOL
    • CREATE CONNECTIVITY_POOL
    • DROP CONNECTIVITY_POOL
    • ALTER CONNECTIVITY_POOL
      • ALTER CONNECTIVITY_POOL SET
      • ALTER CONNECTIVITY_POOL RENAME TO
      • ALTER CONNECTIVITY_POOL ADD PARTICIPANTS
      • ALTER CONNECTIVITY_POOL DROP PARTICIPANTS
  • SYSTEM
    • ALTER SYSTEM ALTER CONFIG SET
    • ALTER SYSTEM RENAME TO
    • ALTER SYSTEM ALTER METRIC LEVEL

Database, Tables, Views, and Indexes

  • DATABASE
    • CREATE DATABASE
    • DROP DATABASE
    • ALTER DATABASE
      • ALTER DATABASE RENAME
      • ALTER DATABASE SET SSO CONNECTION
      • ALTER DATABASE ALTER SSO CONNECTION
      • ALTER DATABASE REMOVE SSO CONNECTION
  • TABLE
    • CREATE TABLE
    • CREATE TABLE AS SELECT (CTAS)
    • DROP TABLE
    • ALTER TABLE
      • ALTER TABLE RENAME
      • ALTER TABLE RENAME COLUMN
      • ALTER TABLE ADD COLUMN
      • ALTER TABLE ALTER COLUMN COMPRESSION
      • ALTER TABLE ALTER REDUNDANCY
      • ALTER TABLE DROP COLUMN
      • ALTER TABLE STREAMLOADER_PROPERTIES
      • ALTER TABLE DISABLE INDEX
      • ALTER TABLE ENABLE INDEX
    • DELETE FROM TABLE
    • EXPORT TABLE
    • INSERT INTO TABLE
      • INSERT INTO TABLE USING LOADERS
    • TRUNCATE TABLE
  • VIEW
    • CREATE VIEW
    • DROP VIEW
    • ALTER VIEW RENAME
    • ALTER VIEW AS
    • EXPORT VIEW
  • INDEX
    • CREATE INDEX
    • DROP INDEX

Rebuild Tasks and Check Data

  • TASK
    • CREATE TASK
    • CANCEL TASK

Users, Groups, and Service Classes

  • USER
    • CREATE USER
    • DROP USER
    • ALTER USER
  • GROUP
    • CREATE GROUP
    • DROP GROUP
    • ALTER GROUP
      • ALTER GROUP USER
      • ALTER GROUP RENAME
      • ALTER GROUP SET SERVICE CLASS
  • SERVICE CLASS
    • CREATE SERVICE CLASS
    • DROP SERVICE CLASS
    • ALTER SERVICE CLASS
      • ALTER SERVICE CLASS RENAME
      • ALTER SERVICE CLASS SET
      • ALTER SERVICE CLASS RESET
    • ALTER QUERY

Data Integrity and Storage

  • ALTER SEGMENT QUARANTINE

Query Analysis

  • EXPLAIN
  • EXPLAIN PIPELINE

Statistics Cache Management



Updated 22 May 2024
Did this page help you?
PREVIOUS
Other Functions and Expressions
NEXT
Cluster and Node Management
Docs powered by Archbee