DDL语法

DDL语法一览表

ALTER BLOCK RULE

ALTER DATABASE

ALTER EXCEPT RULE

ALTER EXTERNAL SCHEMA

ALTER FOREIGN TABLE (GDS导入导出)

ALTER FOREIGN TABLE (For HDFS or OBS)

ALTER FUNCTION

ALTER GROUP

ALTER INDEX

ALTER LARGE OBJECT

ALTER MATERIALIZED VIEW

ALTER NODE GROUP

ALTER PUBLICATION

ALTER REDACTION POLICY

ALTER RESOURCE POOL

ALTER ROLE

ALTER SUBSCRIPTION

ALTER ROW LEVEL SECURITY POLICY

ALTER SCHEMA

ALTER SEQUENCE

ALTER SERVER

ALTER SESSION

ALTER SYNONYM

ALTER SYSTEM KILL SESSION

ALTER TABLE

ALTER TABLE PARTITION

ALTER TEXT SEARCH CONFIGURATION

ALTER TEXT SEARCH DICTIONARY

ALTER TRIGGER

ALTER TYPE

ALTER USER

ALTER VIEW

CLEAN CONNECTION

CLOSE

CLUSTER

COMMENT

CREATE BARRIER

CREATE BLOCK RULE

CREATE DATABASE

CREATE EXCEPT RULE

CREATE EXTERNAL SCHEMA

CREATE FOREIGN TABLE (GDS导入导出)

CREATE FOREIGN TABLE (SQL on OBS or Hadoop)

CREATE FOREIGN TABLE (OBS导入导出)

CREATE FUNCTION

CREATE GROUP

CREATE INDEX

CREATE MATERIALIZED VIEW

CREATE NODE GROUP

CREATE OUTLINE

CREATE PROCEDURE

CREATE PUBLICATION

CREATE REDACTION POLICY

CREATE ROW LEVEL SECURITY POLICY

CREATE RESOURCE POOL

CREATE ROLE

CREATE SCHEMA

CREATE SEQUENCE

CREATE SERVER

CREATE STATISTICS

CREATE SUBSCRIPTION

CREATE SYNONYM

CREATE TABLE

CREATE TABLE AS

CREATE TABLE PARTITION

CREATE TEXT SEARCH CONFIGURATION

CREATE TEXT SEARCH DICTIONARY

CREATE TRIGGER

CREATE TYPE

CREATE USER

CREATE VIEW

CURSOR

DISCARD

DROP BLOCK RULE

DROP DATABASE

DROP EXCEPT RULE

DROP FOREIGN TABLE

DROP FUNCTION

DROP GROUP

DROP INDEX

DROP MATERIALIZED VIEW

DROP NODE GROUP

DROP OUTLINE

DROP OWNED

DROP PUBLICATION

DROP REDACTION POLICY

DROP ROW LEVEL SECURITY POLICY

DROP PROCEDURE

DROP RESOURCE POOL

DROP ROLE

DROP SCHEMA

DROP SEQUENCE

DROP SERVER

DROP STATISTICS

DROP SUBSCRIPTION

DROP SYNONYM

DROP TABLE

DROP TEXT SEARCH CONFIGURATION

DROP TEXT SEARCH DICTIONARY

DROP TRIGGER

DROP TYPE

DROP USER

DROP VIEW

FETCH

MOVE

REFRESH MATERIALIZED VIEW

REINDEX

RENAME TABLE

RESET

SET

SET CONSTRAINTS

SET ROLE

SET SESSION AUTHORIZATION

SHOW

TRUNCATE

VACUUM