Help Center/ GaussDB/ Developer Guide(Centralized_V2.0-2.x)/ SQL Reference/ Appendix/ Extended Syntax
Updated on 2025-08-19 GMT+08:00
View PDF

Extended Syntax

GaussDB provides the following extended syntax:

Table 1 Extended SQL syntax

Category

Keyword

Description

Creating a table

INHERITS ( parent_table [, ... ] )

Currently, the syntax of inherited tables is retained but is not supported.

column_constraint:

REFERENCES reftable

[ ( refcolumn ) ] [ MATCH

FULL | MATCH PARTIAL |

MATCH SIMPLE ][ ON

DELETE action ] [ ON

UPDATE action ]

You can run REFERENCES reftable[(refcolumn)] [MATCH FULL |MATCH PARTIAL | MATCH SIMPLE] [ON DELETE action] [ON UPDATE action] to create foreign key constraints for tables.

Aggregate functions

CREATE AGGREGATE

Defines a new aggregate function.

ALTER AGGREGATE

Alters the definition of an aggregate function.

DROP AGGREGATE

Drops an existing aggregate function.
Parent topic: Appendix