set schema hcgpl;

CREATE TABLE Persons_Backup
(
P_Id int,
LastName varchar(55),
FirstName varchar(55),
Address varchar(55),
City varchar(55)
)

set schema hcgpl;

insert into persons values(1, 'KING', 'CURT', '14218 ROYAL HILL DR.', 'HOUSTON');

SET SCHEMA HCGPL;
DROP TABLE PERSONS;

SET SCHEMA HCGPL;
SELECT * FROM PERSONS;

SET SCHEMA HCGPL;
 INSERT INTO PERSONS_BACKUP
     SELECT * FROM PERSONS;