Create a copy of a table within the same database DB2

copy db2 aix
Govind Kailas picture Govind Kailas · Jul 10, 2012 · Viewed 159.6k times · Source

Is there an easy way to copy a table to the same database of course with different name. I tried some of these listed below,

db2 "CREATE TABLE SCHEMA.NEW_TB COPY AS SELECT * FROM SCHEMA.OLD_TB WHERE 1 = 2"

db2 "SELECT INTO SCHEMA.NEW_TB FROM SCHEMA.OLD_TB"

db2 "SELECT * FROM SCHEMA.OLD_TB INSERT INTO SCHEMA.NEW_TB"

None of these worked I am using db2 v9.5

Answer

Gilbert Le Blanc picture Gilbert Le Blanc · Jul 10, 2012

Try this:

CREATE TABLE SCHEMA.NEW_TB LIKE SCHEMA.OLD_TB;
INSERT INTO SCHEMA.NEW_TB (SELECT * FROM SCHEMA.OLD_TB);

Options that are not copied include:

  • Check constraints
  • Column default values
  • Column comments
  • Foreign keys
  • Logged and compact option on BLOB columns
  • Distinct types

Related questions

How do I copy a folder from remote to local using scp?

How do I copy a folder from remote to local host using scp? I use ssh to log in my server. Then, I would like to copy the remote folder foo to local /home/user/Desktop. How do I achieve …

Read More
How do I copy a file in Python?

How do I copy a file in Python? I couldn't find anything under os.

Read More
List changes unexpectedly after assignment. How do I clone or copy it to prevent this?

While using new_list = my_list, any modifications to new_list changes my_list everytime. Why is this, and how can I clone or copy the list to prevent it?

Read More