title: Dropping unsigned index foreign key in laravel. Syntax error or access violation: 1091 Can't DROP; check that column/key exists
body: <p>I created migration using the following</p>
  
  <pre><code>Schema::table('packages', function (Blueprint $table) {
       $table-&gt;integer('star_id')-&gt;unsigned()-&gt;index()-&gt;nullable()-&gt;default(null);
       $table-&gt;foreign('star_id')-&gt;references('id')-&gt;on('star');
  });
  </code></pre>
  
  <p>in drop part</p>
  
  <pre><code>Schema::table('packages', function (Blueprint $table) {
        $table-&gt;dropForeign('star_id');
        //$table-&gt;dropIndex('star_id'); //also tried dropIndex
        $table-&gt;dropColumn('star_id');
   });
  </code></pre>
  
  <p>but it throws for index and foreign</p>
  
  <blockquote>
    <p>SQLSTATE[HY000]: General error: 1553 Cannot drop index
    'packages_star_id_index': needed in a foreign key constraint (SQL:
    alter table <code>packages</code> drop <code>star_id</code>)</p>
  </blockquote>
  
  <p>error for dropForeign</p>
  
  <blockquote>
    <p>SQLSTATE[42000]: Syntax error or access violation: 1091 Can't DROP
    'star_id'; check that column/key exists (SQL: alter table <code>packages</code>
    drop foreign key <code>star_id</code>)</p>
  </blockquote>
  
  <p>I cannot rollback because of the error.</p>