The DDL and Database Objects

The DDL is used to create, modify, and destroy database objects. Four types of DDL statements correspond to the following types of tasks:

  • CREATE is used to create database objects.

  • DROP is used to delete database objects or remove constraint definitions from them.

  • ALTER is used to modify an existing database object.

  • DECLARE is used for creating temporary objects.

We will discuss how DDL is used to manage the following types of objects:

  • Tables

  • Indexes

  • Views

  • Schemas

Tables

A table is an unordered set of data records that consists of columns and rows. Each row is commonly known as a record, and consists of one or more columns. Each column is a piece of data with a data type. There are three types of tables:

  • Permanent (base) ...

Get DB2® Universal Database™ v8 Application Development Certification Guide, 2nd Edition 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