Enable or Disable Schema Replication
Run at the publisher to enable or disable the automatic replication of schema changes.
--Enable schema change replication:
EXEC sp_changepublication
@publication = 'publication_name',
@property = 'replicate_ddl',
@value = 1, --Enable
@force_invalidate_snapshot = 0,
@force_reinit_subscription = 0
--Disable schema change replication:
EXEC sp_changepublication
@publication = 'publication_name',
@property = 'replicate_ddl',
@value = 0, --Disable
@force_invalidate_snapshot = 0,
@force_reinit_subscription = 0