Home | Previous Page | Next Page

The Table Option

In This Chapter

Creating or Altering a Table

The CREATE TABLE Screen

The ALTER TABLE Screen

Using the Schema Editor

Adding Columns to a Table (Add Option)

Column Data Type

Data Length or Range

Column Index Fill Factor

Null Value Permission

Building the Table (Exit Option)

Modifying Columns (Modify Option)

Deleting Columns (Drop Option)

Arranging Storage and Locking (Table_options)

Selecting Dbspaces

Fragmenting a New Table

Altering Fragmentation for an Existing Table

Attaching a Dbspace

Detaching a Dbspace

Fragmenting an Existing Table

Setting the Extent Size

Determining the Lock Mode

Adding or Dropping Rowids

Defining Constraints

Defining Primary-Key Constraints

Defining Foreign-Key Constraints

Defining Check Constraints

Defining Unique Constraints

Defining Default Values

Displaying Table Information

Displaying Column Information

DB-Access Data Types

Extended Data Types in Dynamic Server

Displaying Index Information

Displaying Table-Level Privileges

Displaying References Privileges

Displaying Column Constraints and Defaults

Displaying Referential Constraints

Sample Primary and Check Constraint Displays

Displaying Triggers

Displaying Fragmentation Information

Dropping a Table

Moving a Table (XPS)

Related Manuals

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]