Data Definition Language (DDL) Statement Reference

ddl statements allow users to run commands and administrative operations on the system you can execute ddl statements 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, and so on for details, see identifiers docid\ ijwjcqneu43n0yhmibnvz 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 (for example e'\n' ) ddl statements are supported for these categories cluster and node management docid\ os6ixwvq3vqyxxebcnfde cluster create cluster drop cluster alter cluster alter cluster add participants alter cluster drop participants alter cluster add storagespace alter cluster remove storagespace alter cluster alter config set alter cluster alter log level 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 alter participant alter connectivity pool drop participants alter connectivity pool set sso integration alter connectivity pool remove sso integration sso integration create sso integration drop sso integration alter sso integration system alter system alter config set alter system rename to alter system alter metric level alter system alter security alter system set default storagespace schemas docid\ afuz9fotopc8jqgletoat create schema drop schema alter schema rename databases docid 5gexlsola5mpwhnhlm8zn create database drop database alter database alter database rename alter database set sso integration alter database alter sso integration alter database remove sso integration alter database alter security tables docid tp6ahq7papbrxirtqxyn create table create table as select (ctas) create table as select using loaders 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 alter table enable retention policy age alter table disable retention policy delete from table export table insert into table insert into table using loaders truncate table views docid 31awiak6ah4wluypz1tmi create view drop view alter view rename alter view as export view indexes docid 1 xil30f18pjfnfxu4khl create index drop index data pipelines docid 0qxabe6vs9pbygbrfmnah pipeline create pipeline drop pipeline preview pipeline start pipeline stop pipeline alter pipeline alter pipeline rename export pipeline create pipeline function drop pipeline function distributed tasks docid\ nzcumjzl9xke v0x8uxho task create task cancel task machine learning models docid\ cvgbq68buupk4dltsgj2v create mlmodel alter mlmodel drop mlmodel export mlmodel refresh mlmodel users, groups, and service classes docid\ tltjovpwkjdggrcxmy2ov user create user drop user alter user alter user set group create group drop group alter group alter group user alter group rename alter group set service class alter group alter security 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 docid 7tj31yczxztnkp54z92fa drain pages alter segment quarantine query analysis docid\ tu2oj1nn9zxenlht1nky3 explain explain pipeline query management docid\ yazxwbhdbpfwaehfgf6o9 cancel kill statistics cache management docid\ z z mpwmx8es7g4fsmjlb