Data Replication with SQL Remote
   PART 4. Reference
     CHAPTER 18. Command Reference for Adaptive Server Enterprise       

sp_drop_publication procedure

Purpose 

To drop a publication from the database.

Syntax 

sp_drop_publication publication_name

Argument	Description
publication_name	The name of the publication to be dropped

See also 

sp_create_publication procedure

Description 

Running sp_drop_publication drops a publication from the database. All articles that make up the publication, and subscriptions to the publication, are also dropped.

Example 

• The following statement drops the publication named SalesRep:

sp_drop_publication 'SalesRep'
go