title: Unique Indexes query for HSQLDB
body: <p>I've got a query that selects unique indexes from a MySQL DB table:</p>
  <pre><code>SHOW indexes from [tablename] WHERE non_unique = FALSE and key_name &lt;&gt; &quot;PRIMARY&quot;
  </code></pre>
  <p>I am looking to create the equivalent query that works for HSQLDB</p>
  <p>Any help is much appreciated!</p>