According to BOL , “ALTER VIEW can be applied to indexed views; however, ALTER VIEW unconditionally drops all indexes on the view .” We can see this behavior by creating an indexed view using the Northwind database. The script is shown below: CREATE VIEW...