title: How to delete unique index referenced by foreign keys?
body: <p>I have a table, let's call it <code>Users</code>. This table has primary key called <code>Id</code>. Despite having <code>Id</code> as primary key (unique clustered), it has other index (unique nonclustered) on the same column(<code>Id</code>). </p>
  
  <p>I would like to drop this constraint, but foreign keys reference this unique nonclustered index and I get <code>The constraint ... is being referenced by table...</code> error. </p>
  
  <p>What is the best way to drop such index? Do you have any scripts that drop, do something, and recreate foreign key on specific column in specific table? There is a lot of foreign keys, so it would be nice if I could do it automatically. I could use INFORMATION_SCHEMA and other system object to extract information about these keys, but I don't want to write, what have already been written or can be done in other way.</p>