DDL Syntax

DDL Syntax Overview
ALTER BLOCK RULE
ALTER DATABASE
ALTER EXCEPT RULE
ALTER EXTERNAL SCHEMA
ALTER FOREIGN TABLE (GDS Import and Export)
ALTER FOREIGN TABLE (for HDFS or OBS)
ALTER FOREIGN TABLE (SQL on other GaussDB(DWS))
ALTER FUNCTION
ALTER GROUP
ALTER INDEX
ALTER LARGE OBJECT
ALTER MATERIALIZED VIEW
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 (for GDS Import and Export)
CREATE FOREIGN TABLE (SQL on OBS or Hadoop)
CREATE FOREIGN TABLE (for OBS Import and Export)
CREATE FOREIGN TABLE (SQL on other GaussDB(DWS))
CREATE FUNCTION
CREATE GROUP
CREATE INDEX
CREATE MATERIALIZED VIEW
CREATE PROCEDURE
CREATE PUBLICATION
CREATE REDACTION POLICY
CREATE ROW LEVEL SECURITY POLICY
CREATE RESOURCE POOL
CREATE ROLE
CREATE SCHEMA
CREATE SEQUENCE
CREATE SERVER
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 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 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

Previous topic: Transaction Management

Next topic: DDL Syntax Overview

Feedback

Was this page helpful?

Helpful Not helpful

Provide feedback

Thank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.

The system is busy. Please try again later.

Which of the following issues have you encountered?

Content is inconsistent with the product UI

Unclear descriptions

Lack of examples or code

Incorrect steps

Can't find what I need

Lack of best practices

Feedback (optional)

0/500

Select at least one type of issue, and enter your comments or suggestions.

Enter a maximum of 500 characters.

Submit Cancel

For any further questions, feel free to contact us through the chatbot.

Chatbot