title: Finding Indexes For A Table in Sybase
body: <p>I am currently working in an environment where I am made double blind.</p>
  
  <ol>
  <li>I have to email any queries I need to run to a employee of the client  </li>
  <li>That employee runs them in a SAS client, with an odbc connection to SyBase  </li>
  </ol>
  
  <p>I need to find out how to ascertain exactly what indexes exist on a specific table.  I would use <code>sp_helpindex</code>, but apparently it doesn't exist on their instance of SyBase.</p>
  
  <p>We <em>believe</em> that it is SyBase 12, but again I can't be certain of anything.</p>
  
  <p>Does anyone have SQL for...<br>
  - Confirming exactly what version of SyBase we're working on?<br>
  - The details of all indexes that exist for a given table?  </p>