In this blog post, you’ll learn more about the Sybase Error Cannot drop last unique index of an immediate materialized view and the reason for receiving this error
Sybase SQL Error Message
Cannot drop last unique index of an immediate materialized view
Reason for this Error
You attempted to drop the last unique index on non-nullable columns of an immediate materialized view. Immediate materialized view needs at least one unique index on non-nullable columns to be valid.