title: Creating index if index doesn't exist
body: <p>I have a problem creating an index with the advantage database server if it doesn't exist with a sql query.</p>
  
  <p>My query looks like this:</p>
  
  <pre><code> If not Exists(&lt;SELECT Query for amount of indizes for one column&gt;) then 
   Create Index Test on Tablename (No); endif
  </code></pre>
  
  <p>So I don't use FullTextSearchIndizes,because it is a integer field. Otherwhise it would look like this:</p>
  
  <pre><code> If not Exists(SELECT * FROM tablename WHERE CONTAINS( * , 'Test' )) then 
   Create Index Test on Tablename (Name) Content; endif     
  </code></pre>
  
  <p>So, my only problem is how do I get the indices. I've read in other DBMS you can use <code>sys.indexes</code> and some other things.</p>