You can copy a field from one table to another table in the working database.

To copy a field from one table to another:

  1. Choose Schema > Field Editor. The Field Editor alphabetically lists all the tables defined for your database.
  2. Select the table to which you want to copy the field. The Field Editor lists all the fields defined for the selected table.
  3. Choose the Copy option from the menu at the bottom of the window.
  4. Select the table from which you want to copy the field. The Field Editor alphabetically lists all the fields defined for that table.
  5. Select the fields you want to copy, then press GO. The Field Editor copies the specified fields into the table you selected. The main menu of the Field Editor reappears.
  6. Choose Exit to apply the change. The Data Dictionary displays an alert box asking if you want to apply or undo the changes to the database, or if you want to make other changes.
  7. Choose Apply Changes. The main window of the Data Dictionary reappears.
    Note: If you are copying fields within a multi-tenant database, and you are copying a field from a multi-tenant table that has no default area, to either a shared table or a multi-tenant table with a default area, you are prompted to specify an area for the field or you can chose to skip copying the field.