How you can identify foreign type in MySQL DB Table?

From http://dev.mysql.com/doc/refman/5.1/en/innodb-foreign-key-constraints.html

SHOW CREATE TABLE tbl_title

You may also display the foreign key constraints for any table such as this:

SHOW TABLE STATUS FROM db_title LIKE 'tbl_name'