Informix Guide to SQL: Tutorial

Informix Guide to SQL: Tutorial
Chapter 10: Understanding Complex Data Types

Home Contents Index Master Index New Book

Understanding Complex Data Types

What Are Complex Data Types?

Named Row Types

: When to Use a Named Row Type
: Choosing a Name for a Named Row Type
: Restrictions on Named Row Types
: Using a Named Row Type to Create a Typed Table
: Converting an Untyped Table into a Typed Table
: Using a Named Row Type to Create a Column
: Using a Named Row Type Within Another Named Row Type
: Dropping Named Row Types

Unnamed Row Types

: Restrictions on Data Types Allowed in Unnamed Row Types

Collection Data Types

: Null Values in Collections
: Using a Set
: Using a Multiset
: Using a List
: Nesting Collection Types
: Adding a Collection Type to an Existing Table
: Restrictions on Data Types Allowed in Collections

What Is Inheritance?

Type Inheritance

: Defining a Type Hierarchy
: Overloading Routines for Types in a Type Hierarchy
: Inheritance and Type Substitutability
: Dropping Named Row Types from a Type Hierarchy
: Restrictions on Type Hierarchies

Table Inheritance

: The Relationship Between Type and Table Hierarchies
: Defining a Table Hierarchy
: Inheritance of Table Behavior in a Table Hierarchy
: Modifying Table Behavior in a Table Hierarchy
: Adding a New Table to a Table Hierarchy
: Dropping a Table in a Table Hierarchy
: Altering the Structure of a Table in a Table Hierarchy
: Querying Tables in a Table Hierarchy
: Creating a View on a Table in a Table Hierarchy

Informix Guide to SQL: Tutorial, version 9.1
Copyright © 1998, Informix Software, Inc. All rights reserved.