Maintaining Personal Tables › Changing a Table That Contains Data

Changing a Table That Contains Data

You cannot change a table's actual structure once that table has been added to your personal database. To create a table that is somewhat different from an existing table, you can copy the definition to a new table and reenter the data.

Although you cannot change the structure of a table, there is a way to make some minimal changes without having to re-type data. Define a new table and use SUBSELECT to copy the data into it. Using this feature, you can, in effect, rename, add or delete columns in the new table. Or, use the STORE command to create a personal table from query output. See the CA Dataquery Reference Guide for instructions on using this SQL keyword.