MySQL Forums :: Newbie :: dropping a foreign key constraint


Advanced Search

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 Angelo Chen 07/01/2009 06:30AM
Re: dropping a foreign key constraint Jaime Crespo 07/02/2009 08:39AM
Re: dropping a foreign key constraint Angelo Chen 07/02/2009 10:44PM
Re: dropping a foreign key constraint Jaime Crespo 07/03/2009 04:32AM


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.