title: Create a copy of a table within the same database DB2
body: <p>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,</p>
  
  <p><code>db2 "CREATE TABLE SCHEMA.NEW_TB COPY AS SELECT * FROM  SCHEMA.OLD_TB WHERE 1 = 2"</code></p>
  
  <p><code>db2 "SELECT INTO SCHEMA.NEW_TB FROM SCHEMA.OLD_TB"</code></p>
  
  <p><code>db2 "SELECT * FROM SCHEMA.OLD_TB INSERT INTO SCHEMA.NEW_TB"</code></p>
  
  <p>None of these worked 
  I am using db2 v9.5 </p>