title: Determine InnoDB FK Constraints without information_schema
body: <p>I'm writing some code to inspect a MySQL database structure, and need information about Foreign Key constraints (on InnoDB tables).</p>
  
  <p>There are two ways I know of to do this:</p>
  
  <ol>
  <li>Parse the results of <code>SHOW CREATE TABLE X</code></li>
  <li>Use <code>INFORMATION_SCEMA.REFERENTIAL_CONSTRAINTS</code></li>
  </ol>
  
  <p>Unfortunately option two requires MySQL 5.1.16 or later, so I can't use it unless/until I can convince our server guy to update, And while I can probably get away with option 1, it feels messy and without writing a full SQL parser I wouldn't feel sure my code would always work with any table.</p>
  
  <p>Is there another way of getting at this information?</p>
  
  <p>Thanks</p>