Help Center> Data Warehouse Service> Developer Guide> System Overview> SQL Syntax
View PDF

SQL Syntax

Structured Query Language (SQL) is the standard language on relational databases (RDB). SQL is a universal and useful RDB language.

GaussDB(DWS) supports most SQL standards.

GaussDB(DWS) has the following constraints in terms of the compatibility with SQL standards:

  • The SERIALIZABLE transaction isolation level is not supported.
  • The PREPARE statement does not support complex queries.
  • The row-level trigger and COPY cannot be used together.
  • CREATE TABLE AS EXECUTE cannot be used.
  • WHERE CURRENT OF cannot be used.
  • A cursor does not support MOVE BACKWARD.
  • FOREIGN DATA WRAPPER cannot be used.
  • LISTEN, UNLISTEN, and NOTIFY are supported only on CNs.
  • SECURITY LABEL cannot be used.
  • The distribution columns in a table cannot be updated.

For details about the error messages during SQL execution, see Error Code Reference.

Parent topic: System Overview