Copying a table

Use the Copy Table window to create a basic copy of the table that you selected. A new table is defined based on the definition of the selected table, and the contents are copied to the new table. You can copy a table into the same database or a different database.

Fields and controls

Authorities and privileges



To copy a table:

  1. Open the Copy Table window.

  2. In the System box, specify the name of an existing host or server for the target table.

  3. In the Instance box, specify the instance that contains the database that will contain the target table.

  4. In the Database box, specify the database that will contain the target table.

  5. In the Table schema box, specify the schema for the target table.

  6. In the Table name field, type a unique name for the target table. If a table with the same name already exists in the schema, the copy will fail.

  7. Optional: In the Table space box, select a table space for the target table.

    Select a REGULAR DMS table space other than the default table space if you want to specify an index table space or long data table space.

  8. Optional: In the Index table space box, select a table space in which to create any indexes on the target table.

  9. Optional: In the Long data table space box, select a table space in which to store the values of any long columns in the target table.

  10. Click on OK. The table you selected is copied to the target table.


Related information