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
- 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
- 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
- TASK
- CREATE TASK
- CANCEL TASK
- 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
- ALTER SEGMENT QUARANTINE
- EXPLAIN
- EXPLAIN PIPELINE