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
Updated 11 Jan 2024
Did this page help you?