Contents Index sp_create_publication procedure sp_drop_remote_type procedure

SQL Remote User's Guide
  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

DROP PUBLICATION statement

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 
sp_drop_publication 'SalesRep'
go

Contents Index sp_create_publication procedure sp_drop_remote_type procedure