AX2614

Cloning a table

When you clone a table, all of the existing table settings and structure can be copied to a new table. You also have the option to do the following as part of the process:

  • Copy table data
  • Copy table security

Only administrators and users with the Administer Tables permission can clone a table.

NOTE: Document reference tables cannot be cloned, because they are controlled by the source file. Instead, you could copy the source file, modify the source file as needed (including specifying a new table name), and then execute a save-to-database to create the new table.

To clone a table:

  1. On the Axiom tab, in the Administration group, click Tables > Table Administration > Manage Tables.

    The Axiom Explorer dialog opens, with the focus on the Table Library.

    NOTE: If you are using an Axiom packaged product, you can access this feature from the Admin tab. Click System Browser to open Axiom Explorer, then navigate to the Table Library.

  2. In the Table Library folder, navigate to the table that you want to clone, then right-click that table and click Clone.

    You can view the list of tables by folder, by table, or by table type. By default, tables are displayed by folder. If you want to change the display, right-click the Table Library folder and then use the View menu to select the desired view.

    The Clone Table wizard opens, with all of the settings inherited from the cloned table.

  3. On the first screen of the wizard, do the following:

    • In the Table Name box, define a name for the new table. By default, the table name is "CopyofClonedTable".

    • Decide whether you want to copy the current table's security settings to the new table. By default, security settings will be copied to the new table. If you do not want to copy security, then clear the check box for Copy Table Security at the bottom of the screen.

      Keep in mind that if the new table does not belong to a table type, then no non-admin users will be able to access the table once it is copied, unless you copy the current table's security. If you do not want to copy security, then you may need to edit security settings after creating the table.

  4. Change any other table properties as desired for the new table. You can click Previous and Next to move through the wizard screens. When you are finished editing settings, click Finish.

    A confirmation dialog displays the name of the new table and the columns to be created.

  5. If you want to copy data from the original table to the new table, then at the bottom of the confirmation dialog, select Open Copy Data dialog. Click OK to continue.

    The new table is created. If you did not select to copy data, the process is complete. If you did select to copy data, then the Copy Table Data dialog opens, and is automatically populated with the settings to copy data from the cloned table to the new table.

  6. Edit any of the copy data settings as desired, and then click Copy.