title: Changing the size of a column referenced by a schema-bound view in SQL Server
body: <p>I'm trying to change the size of a column in sql server using:</p>
  
  <pre><code>ALTER TABLE [dbo].[Address]
  ALTER COLUMN [Addr1] [nvarchar](80) NULL
  </code></pre>
  
  <p>where the length of <code>Addr1</code> was originally <code>40</code>.</p>
  
  <p>It failed, raising this error:</p>
  
  <pre><code>The object 'Address_e' is dependent on column 'Addr1'.
  ALTER TABLE ALTER COLUMN Addr1 failed because one or more objects access 
  this column.
  </code></pre>
  
  <p>I've tried to read up on it and it seems that because some views are referencing this column and it seems that SQL Server is actually trying to drop the column that raised the error.</p>
  
  <p><code>Address_e</code> is a view created by the previous DB Administrator.</p>
  
  <p>Is there any other way I can change the size of the column?</p>