On, Off

Off

This option is used by SQL Remote only. When it is set to On, messages that contain updates published by the local database are sent with all column values included, and a conflict in any column triggers a RESOLVE UPDATE trigger at the subscriber database.

The following statement sets the verify_all_columns option to Off in SQL Anywhere, for all users:

SET OPTION PUBLIC.verify_all_columns = 'Off';

• SQL Remote options
• Using the verify_all_columns option