Managing publications and subscriptions

Publications and subscriptions are always defined within the context of a database connection. Each publication or subscription is associated with a specific database connection.

Table 3-4 lists the ASE Replicator procedures you can use to manage publications and subscriptions.

**Table 3-4: ASE Replicator publication and subscription procedures**
Procedure	Description
sp_addpub	Creates a new publication
sp_addsub	Creates a new subscription for a publication
sp_droppub	Deletes an existing publication
sp_dropsub	Deletes an existing subscription
sp_helppub	Returns information about publications
sp_helpsub	Returns information about subscriptions
sp_helprep	Returns statistics or status information for the replication system, connections, and subscriptions
sp_materializesub	Materializes and validates a subscription
sp_resumesub	Resumes subscriptions
sp_suspendsub	Suspends a specified subscription
sp_validatesub	Validates a subscription