To create, modify, or delete objects in a database, SQL Data Definition Language (DDL) is used.
The DDL contains four main SQL statements:
CREATE <database object>....
The CREATE statement is used to define database objects. Database objects are used for different purposes. Some are used to define a condition or relationship (index, trigger), and others are a logical representation of the data as it is physically stored on disk (table, table space).
The following database objects can be created with the CREATE statement:
AUXILIARY TABLE (LOBs)
DISTINCT TYPE (User-defined data type)
FUNCTION (User-defined functions)