Common SQL DDL Clauses

1

allocate_extent_clause

Not supported.

-

2

constraint

Supported.

-

3

deallocate_unused_clause

Not supported.

-

4

file_specification

Not supported.

-

5

logging_clause

Partially supported, with differences.

• GaussDB does not support the LOGGING and FILESYSTEM_LIKE_LOGGING constraint clauses.
• GaussDB supports only table-level UNLOGGED constraints and does not support column-level UNLOGGED constraints.
• GaussDB uses logging clauses only in the CREATE TABLE, CREATE TABLE AS, and SELECT INTO statements.

6

parallel_clause

Not supported.

-

7

physical_attributes_clause

Partially supported, with differences.

• GaussDB does not support PCTUSED.
• GaussDB uses physical attribute clauses only in the CREATE TABLE and CREATE INDEX statements.

8

size_clause

Not supported.

-

9

storage_clause

Partially supported, with differences.

• In Oracle, storage parameters are specified by the STORAGE clause. In GaussDB, storage parameters are specified by the WITH clause.
• Optional storage parameters in GaussDB are greatly different from those in Oracle. For details, see the GaussDB parameter description in "SQL Reference > SQL Syntax > C > CREATE TABLE" in Developer Guide. WITH ({storage_parameter = value} [, ...]) describes the storage parameters supported by the CREATE TABLE statement.

10

Aggregate function nesting

Supported.

-