What if schema replication changes are disabled in snapshot replication.

Question

I want to know if new table and columns along with data, will be replicated to subscriber database if I have disabled schema replication in publication ? It's snapshot replication. 

Thanks

V Jay 

Answer 1

It will be replicated to subsciber.

The disable property not prevent publish the  new table and columns along with data to be published.

Note:

The ALTER TABLE ... DROP COLUMN statement is always replicated to all Subscribers whose subscription contains the columns being dropped, even if you disable the replication of schema changes.

More information:replicate-schema-changes

Answer 2

Thanks Miaoyuxi. 

Answer 3

You're welcome V Jay Rana.