database foreign key constraint

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 foreig开发者_StackOverflown key constraint error. How do I remove c without removing b?

Delete the foreign keys, then the table.