SQL

Create a table without data

CREATE TABLE SALES.ORDER (CUST CHAR(5), SALES DEC(7,2), ZONE NUM(1,0));

Create a copy of a table with data (simple clone no keys/constraints)

DB2 – CREATE TABLE SALES.COPY AS (SELECT * FROM SALES.ORDER) WITH DATA;