title: Drop a column from table problem (SQL Server 2008)
body: <p>Unable to delete <code>[U_Family]</code> column from table below :</p>
  
  <p>Table CREATE script:</p>
  
  <pre><code>CREATE TABLE [dbo].[Users](
      [U_Id] [int] IDENTITY(101,1) NOT NULL,
      [U_Name] [nvarchar](50) NULL,
      [U_Family] [nvarchar](50) NULL,
   CONSTRAINT [PK_Users] PRIMARY KEY CLUSTERED 
  (
      [U_Id] ASC
  ),
   CONSTRAINT [IX_UserIdUnique] UNIQUE NONCLUSTERED 
  (
      [U_UserId] ASC
  )
  ) ON [PRIMARY]
  GO
  
  CREATE UNIQUE NONCLUSTERED INDEX [IX_Users(UserId)] ON [dbo].[Users] 
  (
      [U_Id] ASC
  )
  INCLUDE ( [U_Name],
  [U_Family]) ) ON [PRIMARY]
  GO
  </code></pre>
  
  <p>error message :</p>
  
  <blockquote>
    <blockquote>
      <p>'Users' table
      - Unable to modify table.   The index 'IX_Users(UserId)' is dependent on
      column 'U_Family'. ALTER TABLE DROP
      COLUMN U_Family failed because one or
      more objects access this column.</p>
    </blockquote>
  </blockquote>
  
  <p>I know that the problem is because of this index :</p>
  
  <pre><code>CREATE UNIQUE NONCLUSTERED INDEX [IX_Users(UserId)] ON [dbo].[Users] 
  (
      [U_Id] ASC
  )
  INCLUDE ( [U_Name],
  [U_Family])) ON [PRIMARY]
  GO
  </code></pre>
  
  <p>but I never found a syntax to edit this index and remove <code>[U_Family]</code> from included columns.</p>
  
  <p>I cannot delete this index because it is used by a foreign key constraint that I should not remove it.</p>
  
  <p>any solution ????</p>
  
  <p>thanks in advance.</p>