Managing Database Objects

To create, modify, or delete objects in a database, SQL DDL is used.

Using SQL 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, tablespace). 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 temporary table

  • Index

  • Procedure (stored procedures)

  • Stogroup ...

Get DB2® Universal Database™ for OS/390™ v7.1 Application 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