About the DDL statement

Data Definition Language (DDL) statements are used to create, update, and delete database objects. OceanBase Database issues an implicit COMMIT statement before and after a DDL statement. Therefore, DDL statements cannot be rolled back. Note

In the command line (CLI) environment of OceanBase Client (OBClient), you can enter a DDL statement after the SQL prompt (>) (the default value is obclient).

You can also enter a DDL statement in the ODC SQL Editor window.

OceanBase DDL supports the following database objects:

• Tables, including constraints and indexes

• Views

• Sequences

• Synonyms

• User-defined functions

• Stored procedures

• Triggers

• Packages and package bodies

• Other objects