title: Cannot drop existing index
body: <p>Service I'm using is DB2 on cloud.</p>
  <p>I have created an index but didn't specify the schema</p>
  <pre><code>CREATE INDEX IDX_TAB1      
  ON SCHEMA1.TAB1 (RECLASS_MONTH DESC)
  ;
  </code></pre>
  <p>It was created in the following INDSCHEMA</p>
  <pre><code>SELECT * FROM syscat.indexes 
      WHERE TABNAME  ='TAB1'
  </code></pre>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>INDSCHEMA</th>
  <th>INDNAME</th>
  <th>TABSCHMA</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>506TEFMHSB</td>
  <td>IDX_TAB1</td>
  <td>SCHEMA1</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>I want to drop it and specify the schema,
  however running the following DROP sql gives me error</p>
  <pre><code>DROP INDEX &quot;506TEFMHSB&quot;.IDX_TAB1
  ; 
  
  Error message
  &quot;506TEFMHSB.IDX_TAB1&quot; is an undefined name.. SQLCODE=-204, SQLSTATE=42704, DRIVER=4.27.25
  </code></pre>
  <p>Or</p>
  <pre><code>DROP INDEX IDX_TAB1
  ;
  
  Error message
  &quot;506TEFMHSB.IDX_TAB1&quot; is an undefined name.. SQLCODE=-204, SQLSTATE=42704, DRIVER=4.27.25
  </code></pre>
  <p>Not sure how I'm supposed to drop this, any help will be appreciated</p>