SQL Query and CMS Database Table Basics
CentreVu Report Designer Version 8 User Guide
Modifying a Table
18-22
Modifying a Table
18
Use the following steps to add, change, or delete columns in an existing
table.
Adding a Column
to a Table
18
1.
On the
INFORMIX Main
Menu, select
Table
.
→
The
Select Database
screen appears.
2.
Press the
key.
→
The
TABLE
menu appears.
3.
Select
Alter
.
→
The
ALTER TABLE
screen
appears. A list of existing
tables also appears.
4.
Enter the name of the table
you want to change, and
press .
→
The
ALTER TABLE
menu
appears.
Return
Return
1.
Select
Add
to add a new
column.
→
The
ADD NAME
screen
appears.
2.
Complete the fields for the
new column.
3.
Press the
key when you
have finished adding the
column(s), and go to Step 3
of “Deleting a Column.”
→
The ALTER TABLE menu
appears.
Del
Summary of Contents for CentreVu Report Designer
Page 4: ......
Page 18: ...Introduction CentreVu Report Designer Version 8 User Guide Related Documents 1 8...
Page 102: ...Edit Inputs CentreVu Report Designer Version 8 User Guide Viewing the Input Window 6 16...
Page 198: ...Format Text CentreVu Report Designer Version 8 User Guide Formatting Text on the Report 15 4...
Page 264: ...Index CentreVu CMS R3V8 Upgrades and Migration IN 10...
Page 266: ......
