Equivalent SELECT for SHOW command

Hello all, Are there any system_table which I can to do a pure SELECT command to get the same results that MySql SHOW command, in the same way that Oracle DB ? Thanks.. - Before posting, please check: http://www.mysql.com/m

INNODB / Foreign Keys / mysqldump

Hello all, I am testing MySql Max 4.0.1 alpha. I have configured innodb tablespace and created the two manual tables example. But when I try to do a mysqldump to re-create the tables on another DB or 'SHOW CREATE TABLE child', NO-FOREIGN key information is gathered on results. However 'SHOW