Copying a table

Use the Copy 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.

Before you begin...

To copy a table:

1. Open the Copy 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

• COPY -- See the Command Reference
• Replication -- See the Replication Guide
• More about systems
• More about instances
• More about databases
• More about schemas

[ Top of Page | Table of Contents | Glossary | Index ]

[ DB2 List of Books | Search the DB2 Books ]