If a DROP TABLE DDL is supported by the publication(s), then the DROP TABLE operation will drop the table from the publication and the database. The log reader agent will post a cleanup command for the distribution database of the dropped table and do the cleanup of the publisher metadata. If the log reader hasn't processed all the log records that refer to the dropped table, then it will ignore new commands that are associated with the dropped table. Already processed records will be delivered to distribution database. They may be applied on Subscriber database if the Distribution Agent processes them before Log Reader cleans up the obsolete (dropped) article(s).
Command to enable drop table support for a publication:
exec sp_changepublication @publication = '<Publication Name>', @property = 'allow_drop', @value = 'true'Command to enable drop table support while you're creating a publication:
exec sp_addpublication @publication = '<Publication Name>', ..., @allow_drop = N'true'The default value of the allow_drop property is set to False.
Service pack informationThis functionality was first introduced in the following service packs for SQL Server:
About Service packs for SQL Server
Service packs are cumulative. Each new service pack contains all the fixes that are in previous service packs, together with any new fixes. Our recommendation is to apply the latest service pack and the latest cumulative update for that service pack. You don't have to install a previous service pack before you install the latest service pack. Use Table 1 in the following article for finding more information about the latest service pack and latest cumulative update.
How to determine the version, edition and update level of SQL Server and its components
Article ID: 3170123 - Last Review: Dec 8, 2016 - Revision: 1