solidDB Help : solidDB reference : SQL: Statements : SET : SET SYNC : SET SYNC PROPERTY
  
SET SYNC PROPERTY
Note Applies to only solidDB Advanced Replication configurations.
Syntax in master database
SET SYNC PROPERTY propertyname = {'value' | NONE} FOR REPLICA replica‑name
Syntax in replica database
SAVE SET SYNC PROPERTY propertyname = {'value' | NONE}Usage
Use the SET SYNC PROPERTY statement in a master database to set a property name and value for a specified replica database.
Use the SAVE SET SYNC PROPERTY statement in a replica database to set a property name and value for the current database.
Replicas that have the same property and property value can be grouped, and the group can be specified when using the START AFTER COMMIT statement. For more information, see Replica property names.
Parameters, clauses, keywords, and variables
▪ NONE: Deletes an existing property.
Examples
Master:
SET SYNC PROPERTY color = 'red' FOR REPLICA replica1;
SET SYNC PROPERTY color = NONE FOR REPLICA replica1;
Replica:
SAVE SET SYNC PROPERTY color = 'red';
SAVE SET SYNC PROPERTY color = NONE;
Go up to
SET SYNC