<p>I'm using system catalog views such as SYS.ALL_ OBJECTS, SYS.FOREIGN_KEYS etc. to get information about my database structure in MS SQL 2005. </p>

<p>Are there equivalent functions/views for MySQL (v. 5) servers? </p>

Hmm, I haven't studied everything it contains, but there's a good deal of information in the
information_schema
.  There's also the
show
command.
Still, I don't see a single command to show all the foreign keys in there.