title: Why am I allowed to have two indices with the same name?
body: <p>I have a large .sqlproj project. In one .sql file I have one table definition:</p>
  
  <pre><code>CREATE TABLE [dbo].[TableOne] (
      [ColumnName] UNIQUEIDENTIFIER NULL
  );
  GO
  CREATE UNIQUE CLUSTERED INDEX [TableOneIndex]
    ON [dbo].[TableOne]([ColumnName] ASC;
  </code></pre>
  
  <p>In another .sql file I have another table definition:</p>
  
  <pre><code>CREATE TABLE [dbo].[TableTwo] (
      [ColumnName] UNIQUEIDENTIFIER NULL
  );
  GO
  CREATE UNIQUE CLUSTERED INDEX [TableOneIndex]
    ON [dbo].[TableTwo]([ColumnName] ASC;
  </code></pre>
  
  <p>Note that both indices are called <code>TableOneIndex</code>. Yet the project builds fine and deploys fine.</p>
  
  <p>How can this be legal?</p>