Typed tables

Creating typed tables
Typed tables are used to actually store instances of objects whose characteristics are defined with the CREATE TYPE statement. You can create a typed table using a variant of the CREATE TABLE statement.

Dropping typed tables
Dropping a typed table is similar to dropping a non-typed table. An important difference is that you must ensure that the table you are dropping has no subtables.

Substitutability in typed tables
When a SELECT, UPDATE, or DELETE statement is applied to a typed table, the operation applies to the named table and all of its subtables.

Storing objects in typed table rows
This topic provides information about storing objects in typed table rows.

Defining system-generated object identifiers
This section provides information about defining system-generated object identifiers.

Defining constraints on object identifier columns
This topic describes how to define constraints on object identifier columns.

Reference types
For every structured type you create, DB2® for Linux, UNIX, and Windows automatically creates a companion type. The companion type is called a reference type and the structured type to which it refers is called a referenced type.