phpmyadmin innodb constraints

Do you have a question? Post it now! No Registration Necessary.  Now with pictures!

Threaded View

I've no access to mysql NG.

I've to drop a field where there is a constraint on an other table.

I'm using phpmyadmin, but can't find any way the name of the constraint, so
if I try to delete the field, I get an error message.

How may I know the constraint and then delete them ?


Re: phpmyadmin innodb constraints

Bob Bedford wrote:
Quoted text here. Click to load it

Do a SHOW CREATE TABLE for the table with the foreign key you want to
remove to find the name of the constraint; then ALTER TABLE table DROP
FOREIGN KEY name_of_constraint.


Real e-mail address unavailable. 5000+ spams per month.

Site Timeline