All Products
Search
Document Center

Comments

Last Updated: Jun 18, 2021

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');