Wednesday 10 May 2017

Create Table structure from another table in DB2 AS400

CREATE TABLE SCHEMA.NEW_TB AS (
    SELECT *
    FROM SCHEMA.OLD_TB
) WITH NO DATA
 
There is no way of copying the table structure and the data in the same way that
you can use SELECT INTO with MS SQL.