Hi, I'm trying to change the size of a column in sql server using:
where the length of Addr1 was originally 40.
It failed, raising this error:
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.
Address_e is a view created by the previous DBA.
Is there any other way I can change the size of the column?
asked Dec 06, 2017 at 06:19 AM in Default
Script out the Address_e view as drop and create, drop the view, modify the column, recreate the view.
As the view is schemabound, the only way to modify the underlying schema is to remove the views dependency on binding.