Cloudsync Commands Reference
Page 6 of 8

DROP PUBLICATION

Removes a publication from a source database. This statement can only be executed on a source database.

Syntax

DROP PUBLICATION PublicationName

Once DROP PUBLICATION is run, the publication is removed, and you cannot make copy files from it, nor can you refresh targets made from it. You can, however, still create target databases from any copy file created from the publication even after the publication is dropped. You can change data in such databases (if they are configured to allow data changes), but any refreshes they issue will fail.

The items specified in the publication are not affected by the DROP PUBLICATION statement.

Example

-- publication is no longer needed, so drop it
DROP PUBLICATION toySales