STOP SYNCHRONIZATION SCHEMA CHANGE

The STOP SYNCHRONIZATION SCHEMA CHANGE statement stops a schema change started by a START SYNCHRONIZATION SCHEMA CHANGE statement. All locks obtained by the START SYNCHRONIZATION SCHEMA CHANGE statement are released.

DBA authority

None.

• START SYNCHRONIZATION SCHEMA CHANGE statement [MobiLink]
• SYSARTICLE system view
• SynchronizationSchemaChangeActive database property

The following sequence of SQL statements illustrates how to use START SYNCHRONIZATION SCHEMA CHANGE and STOP SYNCHRONIZATION SCHEMA CHANGE:

START SYNCHRONIZATION SCHEMA CHANGE
  ON DBA.Sales, DBA.Products
  SET SCRIPT VERSION = 'version 2';
ALTER TABLE DBA.Sales ADD SUBTOTAL NUMERIC (10,2);
ALTER TABLE DBA.Products ALTER QUANTITY BIGINT;
STOP SYNCHRONIZATION SCHEMA CHANGE;