Help Center > > Developer Guide> System Overview> SQL Syntax

SQL Syntax

Updated at: Aug 06, 2020 GMT+08:00

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

DWS supports most SQL standards.

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 SQL execution errors, see Description of SQL Error Codes.

Did you find this page helpful?

Submit successfully!

Thank you for your feedback. Your feedback helps make our documentation better.

Failed to submit the feedback. Please try again later.

Which of the following issues have you encountered?







Please complete at least one feedback item.

Content most length 200 character

Content is empty.

OK Cancel