title: Can not drop UNIQUE index from table
body: <p>When I run this query</p>
  
  <pre><code>ALTER TABLE "dbo"."ROOM" DROP INDEX "UNIQUE";
  </code></pre>
  
  <p>I got this message:</p>
  
  <blockquote>
    <p>Error 1018: Incorrect syntax near 'INDEX'. If this is intended as a part of a table hint, A WITH keyword and parenthesis are now required. See SQL Server Books Online for proper syntax.</p>
  </blockquote>
  
  <p>The name of the unique index is, justly, <code>UNIQUE</code>. I think that is the problem, and it's an autogenerated name (for the SQL Server client that was used to create this index). This is the create table sentence:</p>
  
  <pre><code>CREATE TABLE "ROOM" (
      "ID" BIGINT NOT NULL DEFAULT NULL,
      //the rest of the columns...
      "ROOM" VARCHAR(100),
      UNIQUE INDEX "UNIQUE" ("ROOM")
  )
  ;
  </code></pre>
  
  <p>Any idea how can I remove this index? I know I can drop the table, and create it again, I want to avoid that.</p>