In this blog post, you’ll learn more about the Sybase Error The materialized view cannot be changed to immediate because the primary key columns of any table in the preserved side of an OUTER JOIN must exist in the SELECT list. and the reason for receiving this error
Sybase SQL Error Message
The materialized view cannot be changed to immediate because the primary key columns of any table in the preserved side of an OUTER JOIN must exist in the SELECT list.
Reason for this Error
You attempted to change the refresh type to immediate for a materialized view whose SELECT list doesn’t contain the primary key columns of any table in the preserved side of an OUTER JOIN.
