title: How do you check if a certain index exists in a table?
body: <p>Something like this:</p>
  
  <pre><code>SELECT
  * 
  FROM INFORMATION_SCHEMA.TABLE_CONSTRAINTS 
  WHERE CONSTRAINT_NAME ='FK_TreeNodesBinaryAssets_BinaryAssets'
  and TABLE_NAME = 'TreeNodesBinaryAssets'
  </code></pre>
  
  <p>but for indexes.</p>