Alter Column for change in length

RashmiJain · New User Joined: 04 Aug 2010 Posts: 1 Location: India

If I alter a table for an increase in existing column lenght, then after an ALTER TABLE is executed, is a Drop View and a new CREATE VIEW for that table required?

dbzTHEdinosauer · Posted: Wed Aug 04, 2010 3:54 pm

ALTER TABLE does not affect any view that references the table being altered.
This includes views that have an "*" in their SELECT list.
You must drop and re-create those views if you wish them to return the new columns.