Altering an indexed view in SQL Server drops all indexes
I learned an interesting thing about ALTER VIEW behavior in SQL Server when applied to indexed views. This is covered in the product documentation, but it’s not something I would have expected: ALTER VIEW can be applied to indexed views; however, ALTER VIEW unconditionally drops all indexes on the view. ALTER VIEW documentation When I first heard about this behavior, it sounded like a bug to me: why should an alteration like adding a column to a view remove all the indexes?