Adaptive Server Enterprise and Adaptive Server Anywhere are more liberal than ANSI permits on which view definitions are updatable when the WITH CHECK option is not requested.
Adaptive Server Anywhere offers the ANSI_UPDATE_CONSTRAINTS option to control whether updates are restricted to those supported by SQL92, or a more liberal set of rules.
Sybase IQ permits UPDATE only on single-table views that can be flattened. Sybase IQ does not support WITH CHECK.
