Managing Database Objects

To create, modify, or delete objects in a database, SQL Data Definition Language (DDL) is used.

Using SQL Data Definition Language (DDL)

The DDL contains four main SQL statements:

  • CREATE

  • ALTER

  • DROP

  • DECLARE

The CREATE Statement
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:

  • ALIAS

  • AUXILIARY TABLE (LOBs)

  • DATABASE

  • DISTINCT TYPE (User-defined data type)

  • FUNCTION (User-defined functions)

  • GLOBAL ...

Get DB2® Universal Database for OS/390® Version 7.1 Certification Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial