SELECT * FROM EDEMP0; -- DROP TABLE EDEMPx; CREATE TABLE EDEMPx LIKE EDEMP0; INSERT INTO EDEMPx SELECT EMPNO,SSNO,FNAME,LNAME,DPT FROM EDEMP0; -- SELECT * FROM EDEMPx; -- -- EMPNO CHAR(5) NOT NULL, -- SSNO CHAR(10) NOT NULL, -- FNAME CHAR(20) NOT NULL, -- LNAME CHAR(20) NOT NULL, -- DPT CHAR(5) NOT NULL