SQL Reference

Data Definition Language (DDL) Command Reference

Data Definition Language (DDL) is the SQL syntax for creating and modifying database objects.

 DDL functions are grouped in 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
  • SYSTEM
    • ALTER SYSTEM ALTER CONFIG SET
    • ALTER SYSTEM RENAME TO
  • 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
    • TRUNCATE TABLE
  • VIEW
    • CREATE VIEW
    • DROP VIEW
    • ALTER VIEW RENAME
    • ALTER VIEW AS
  • 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 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 SEGMENT QUARANTINE
  • EXPLAIN
  • EXPLAIN PIPELINE