SQL Management Studio - Raj Kaimal

Browse by Tags

All Tags » SQL Management Studio (RSS)

Altering Indexed Views - Gotcha

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...
Posted by rajbk | with no comments
More Posts