In this blog post, you’ll learn more about the Sybase Error The materialized view cannot be changed to immediate because COUNT(*) must be part of the SELECT list. and the reason for receiving this error
Sybase SQL Error Message
The materialized view cannot be changed to immediate because COUNT(*) must be part of the SELECT list.
Reason for this Error
You attempted to change the refresh type to immediate for a materialized view whose definition does not include COUNT(*) in the SELECT list.