SQL Query and CMS Database Table Basics
CentreVu Report Designer Version 8 User Guide
Modifying a Table
18-23
Changing a
Column
18
Deleting a
Column
18
1.
Select
Modify
to change
a column.
→
The
MODIFY NAME
screen appears.
2.
Use the arrow keys to select
a field to change.
3.
Press the
key when you
have finished changing the
column(s), and go to Step 3
of “
” in
this section.
→
The
ALTER TABLE
menu
appears.
Del
1.
To delete a column, use the
arrow keys to move the
cursor to the column. Select
Drop
.
→
The
REMOVE
screen
appears.
2.
Select
YES
to remove the
column.
→
The column disappears, and
the
ALTER TABLE
menu
appears.
3.
At the
ALTER TABLE
menu, select
Exit
when
you are finished changing
the table.
→
The
Build-new-table
menu appears.
4.
Select
Build-new-table
to save your changes.
Select
Discard-new-
table
to ignore your
changes.
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: ......
