MySQL Forums
Forum List  »  Newbie

dropping a foreign key constraint
Posted by: Angelo Chen
Date: July 01, 2009 06:30AM

Hi,

I have a table which refers to a user:
order | InnoDB free: 5120 kB; (`usr_id`) REFER `inventory/usr`(`id`)
got two questions:

1) How to display the order table complete with foreign keys? now I have to use "show table status" which shows everything
2) How to drop the foreign key constraints from table "order"?

Thanks,

Options: ReplyQuote


Subject
Written By
Posted
dropping a foreign key constraint
July 01, 2009 06:30AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.