Home Forums SQL Server 2005 Development Altering Field Length in Table does not change Field Length in View RE: Altering Field Length in Table does not change Field Length in View

  • Thanks, doing this does cause my field size to display properly and so did scripting out my view and altering it (your suggestion was much faster though!).

    However, I've modified tables without modifying views for years and can't believe I'm just now noticing this. Has it always been this way? The length of a field in views never change when the length of a field changes in a table.