Altering an Indexed View in SQL Server Drops All Indexes
Category:
database-administration
, sql-server
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.