Copying and Editing Table Structure

To modify the structure of an existing table, you can use the Table Designer or ALTER TABLE.

Alternatively, you can create a new table based on the structure of an existing table, then modify the structure of the new table.

To copy and edit a table structure
1. Open the original table.
2. Use the COPY STRUCTURE EXTENDED command to produce a new table containing the structural information of the old table.
3. Edit the new table containing the structural information to alter the structure of any new table created from that information.
4. Create a new table using the CREATE FROM command.
    The new table is empty.
5. Use APPEND FROM or one of the data copying commands to fill the table if necessary.