Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 11.0.1 » SQL Anywhere Server - Database Administration » Configuring Your Database » Database options » Introduction to database options » Alphabetical list of options

 

prevent_article_pkey_update option [database] [MobiLink client]

Controls updates to the primary key columns of tables involved in publications.

Allowed values

On, Off

Default

On

Remarks

Setting this option to On disallows updates to the primary key columns of tables that are part of a publication. This option helps ensure data integrity, especially in a replication and synchronization environment.

Caution

It is strongly recommended that you do not set this option to Off in a synchronization or replication environment.