An existing table is modified in design mode. To do so, click on the table to be modified in the table list and select the Object / Design function or click on the 
toolbar
button to display the definition of the selected table. You can now modify the cardfile cards containing the table definition using the usual Windows editing functions (Edit menu item). As
when a table is created, terminate table modification by selecting the Object / Save function.
Naturally, certain restrictions apply when modifying a table; for more information, refer to the Reference manual.
- The Date Type, Code, Length, and Decimals attributes can be modified, as well as Comment, Default, and Constraint.
- Comments are defined and modified within the table list, as described above.
- You can rename columns by overwriting the old name with the new name.
- You can delete a column by first selecting it and then selecting the Edit / Delete function.
- You can delete a number of columns simultaneously by selecting them one after the other using the Shift key/mouse and then selecting the Edit / Delete function.
If you wish to modify the table structure with the intention of subsequently saving the table under another name, it is recommended that you first transfer the existing table to design mode using Object / Copy (for more information, refer to Section Defining a Table Like Another Table (CREATE Table Like)).