var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: show foreign keys
How can I do to make a SELECT of FK's of a given table?
Do you mean how to show the foreign keys defined for a table?
SHOW CREATE TABLE tablename;
Yes, but I need to drop all constraints of a database.
Originally Posted by tombell
I thought I could do a script in PHP that loops the tables and foreach table, deletes its foreign keys.
Is there any easier way?
Or is there any way to toogle from InnoDB to MyISAM?
In MySQL 5. is very easy with information schema, check this query :
WHERE TABLE_SCHEMA ='mydb' AND TABLE_NAME ='mytable' AND
CONSTRAINT_NAME <>'PRIMARY' AND REFERENCED_TABLE_NAME is not null