title: Msg 5074, Level 16, State 1, Line 1 The index 'IX_Alias_Alias' is dependent on column 'Alias'
body: <p>Want to change the collation</p>
  
  <p>using the below script</p>
  
  <pre><code>ALTER TABLE Alias ALTER COLUMN Alias nvarchar(25) COLLATE SQL_Latin1_General_CP1256_CI_AS
  </code></pre>
  
  <p>Error occurs</p>
  
  <blockquote>
    <p>Msg 5074, Level 16, State 1, Line 1<br>
    The index 'IX_Alias_Alias' is dependent on column 'Alias'.<br>
    Msg 4922, Level 16, State 9, Line 1<br>
    ALTER TABLE ALTER COLUMN Alias failed because one or more objects access this column.</p>
  </blockquote>
  
  <p>Actually I want to change the collation of all the table in database</p>