database foreign key constraint

Question

I have tables a and b; b references a via foreign key.

I copied a using:

create table c select * from a;

Now, I want to delete c only, but I got a foreign key constraint error. How do I remove c without removing b?

Answer 1

Delete the foreign keys, then the table.