Download IBM Informix DB-Access User`s Guide, Version 5.2

Chapter
The Table Menu Option
In This Chapter .
.
.
.
5
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
5-3
Selecting the TABLE Menu .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
5-4
Creating a Table . . . . . . . . . . . . . . . . . . .
The CREATE TABLE Screen . . . . . . . . . . . . .
Naming the Table . . . . . . . . . . . . . . . . .
Building the Table Schema . . . . . . . . . . . . . .
Differences Between IBM Informix OnLine and IBM Informix SE
Exiting the CREATE TABLE Menu . . . . . . . . . . .
Adding a Column to a Table . . . . . . . . . . . . .
The ADD NAME Screen . . . . . . . . . . . . .
Naming the Column . . . . . . . . . . . . . .
Defining the Column Data Type. . . . . . . . . . .
Specifying the Column Length or Other Parameters . . . .
Defining an Index for the Column . . . . . . . . . .
Allowing Null Values in the Column . . . . . . . . .
Adding to the Table Schema . . . . . . . . . . . . .
Building the Table Schema . . . . . . . . . . . . . .
Modifying a Column in a Table . . . . . . . . . . . .
Modifying the Column Name . . . . . . . . . . .
Modifying the Column Data Type . . . . . . . . . .
Modifying the Column Length . . . . . . . . . . .
Modifying the Column Index . . . . . . . . . . .
Modifying the Nulls Entry . . . . . . . . . . . .
Dropping a Column . . . . . . . . . . . . . . . .
Rebuilding the Table Schema . . . . . . . . . . . . .
Displaying Subsequent Table Screens . . . . . . . . . .
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
5-5
5-6
5-6
5-7
5-8
5-8
5-9
5-9
5-11
5-12
5-14
5-15
5-16
5-17
5-17
5-18
5-19
5-21
5-22
5-23
5-24
5-25
5-26
5-27