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:



  • DROP


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:




  • 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.