How can I do to make a SELECT of FK's of a given table?

Thanks!

Do you mean how to show the foreign keys defined for a table?
If so

Yes, but I need to drop all constraints of a database.
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?

Hi,

In MySQL 5. is very easy with information schema, check this query :

SELECT *
FROM information_schema.KEY_COLUMN_USAGE
WHERE TABLE_SCHEMA ='mydb' AND TABLE_NAME ='mytable' AND
CONSTRAINT_NAME <>'PRIMARY' AND REFERENCED_TABLE_NAME is not null


Regards,