DDL statements

Data Definition Language (DDL) statements are used to create, update, and drop database objects. This topic describes the background and supported objects of DDL statements.

Background

OceanBase Database issues an implicit COMMIT statement before and after a DDL statement. Therefore, DDL statements cannot be rolled back.

Note

• In the CLI of OceanBase Client (OBClient), you can enter a DDL statement after the SQL prompt (>).

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

Database objects supported for DDL statements

The following database objects are supported for DDL statements in OceanBase Database:

• Tables, including constraints and indexes

• View

• Sequences

• Synonyms

• User-defined functions

• Stored procedure

• Triggers

• Packages and package bodies