title: Select a list of keys of a table in MySQL
body: <p>Say I have a table "products" and I would like to check if this table has any  indexes, foreign keys etc</p>
  
  <p>A "DESCRIBE products" would give some information.</p>
  
  <pre><code>Field        Type           Null    Key    Default   Extra
  productCode  varchar(200)   NO      MUL    NULL  
  description  varchar(500)   NO             NULL 
  </code></pre>
  
  <p>Mainly the key field in the case. But defenietly no references and what table is linked to who etc etc.</p>
  
  <p>What is the best way to get such information via SQL about a table?</p>
  
  <p>Thanks</p>