create table loan as
select * from loan left join x_loan
on loan.rkid = x_loan.rkid;
rkid is a primary key and with this code of mine integrity is a problem since i recreated the table loan. Is there a way to recreate a table without the integrity? Or are there any steps i can do to achieve what i intend to do?