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