Comments

SQL statements

In general SQL statements, ApsaraDB for OceanBase supports the following three styles for comments:

• From a number sign (#) to the end of the line

• From a symbol (__) to the end of the line

• From a /* symbol to a */ symbol

Database objects

In a data definition language (DDL) statement, you can use the COMMENT clause to specify comments for a database object. Example:

create table t(pk INT PRIMARY KEY COMMENT 'Primary key');