title: Get Foreign keys in the table
body: <p>I created one script to display the foreign keys in the particular table.</p>
  
  <pre><code>SELECT  i.CONSTRAINT_NAME FROM information_schema.TABLE_CONSTRAINTS i
  LEFT JOIN information_schema.KEY_COLUMN_USAGE k ON
  i.CONSTRAINT_NAME = k.CONSTRAINT_NAME WHERE i.CONSTRAINT_TYPE = 'FOREIGN KEY'
  AND i.TABLE_NAME = 'sample';
  </code></pre>
  
  <p>When I execute this command in my host, it displays the list of foreign key constraints found in all the databases with <code>table</code> name <code>"sample"</code>.</p>
  
  <p>But i need particular database, sample table <code>foreign keys</code>.</p>