Appendix: SQL Syntax（1）
Tags: opengauss
Published: 2023-03-10 07:43:20

**ABORT**
Exits the current transaction.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ffulo2vs5fs6bfprxaad.png)

**ALTER AUDIT POLICY**
Modifies the unified audit policy.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/jaocwqlti39o83krcak0.png)

**ALTER DATA SOURCE**
Modifies the attributes and content of the data source.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/qhb7allbtz9l26oct8wh.png)

**ALTER DATABASE**
Modifies a database, including its name, owner, connection limitation, and object isolation.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/p0gci9w20rm8aw6ni6w1.png)

**ALTER DEFAULT PRIVILEGES**
Sets the permissions that will be applied to objects created in the future. (It does not affect permissions granted to existing objects.)

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/puwa6hcxbamm59c7w7s4.png)

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/sdi6d6gtqwaan9zsiv8y.png)

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/av69e9o9m5sp6l13enkb.png)

**ALTER DIRECTORY**
Modifies a directory.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/8tk6vrntwy1r2tea01pc.png)

**ALTER EXTENSION**
Modifies an extension.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/jlp93ewo66hin75cb3gq.png)

**ALTER FUNCTION**
Modifies the attributes of a user-defined function.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/2o9owewqgofr71zhnymo.png)

**ALTER GROUP**
Modifies the attributes of a user group.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/hgb6r8thoaoncpom8094.png)

**ALTER INDEX**
Modifies the definition of an existing index.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/3j2ok9moazxadmctr399.png)

**ALTER LARGE OBJECT**
Modifies the definition of a large object. It is used to assign a new owner.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/8ifc0pkzk4y1g006xhk1.png)

**ALTER MASKING POLICY**
Modifies a masking policy.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/knntgsmmhbdpna05rpdw.png)

**ALTER MATERIALIZED VIEW**
Modifies multiple auxiliary attributes of an existing materialized view.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/sjf3ietn2vk44iujbbqy.png)

**ALTER OPERATOR**
Modifies the definition of an operator.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/q5euo3pseg4eopchh42t.png)

**ALTER RESOURCE LABEL**
Modifies a resource label.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ovu4brv5yk7yxgychx83.png)

**ALTER RESOURCE POOL**
Modifies the Cgroup of a resource pool.

ALTER RESOURCE POOL pool_name
    WITH ({MEM_PERCENT=pct | CONTROL_GROUP="group_name" | ACTIVE_STATEMENTS=stmt | MAX_DOP = dop | MEMORY_LIMIT='memory_size' | io_limits=io_limits | io_priority='priority' | nodegroup='nodegroup_name' }[, ... ]);

**ALTER ROLE**
Modifies role attributes.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/jf8jne2rkydfwhc1yyba.png)

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/d5ezob8wclza1ad22sjg.png)

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/xk5hyhco666t913avsdg.png)

**ALTER ROW LEVEL SECURITY POLICY**
Modifies an existing row-level access control policy, including the policy name and the users and expressions affected by the policy.

![Image description](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/lz8n219n0tafjdw14i7n.png)