Deletes an existing replicate article (or articles) from a specified subscription.
If ASE Replicator creates a replicate table when a replicate
article is created, ASE Replicator deletes the replicate table in the
replicate database when you delete that replicate article.
sp_dropreplicateart sub_name [, rep_art]
The name of the subscription to which the existing article belongs.
The name of a replicate article. Replicate article names can be specified in the form owner.name.
To avoid problems on case-insensitive data servers,
always specify replicate object names using the same character case
as returned by the catalog stored procedures on the replicate data
server.
sp_dropreplicateart subdoc, reptable1
Deletes the replicate article reptable1 in the subscription subdoc.
Before you invoke sp_dropreplicateart, you must suspend the subscription using sp_suspendsub. After the replicate article is deleted, you can resume the subscription using sp_resumesub.
When sp_dropreplicateart is invoked with only a subscription name (sub_name) specified, all replicate articles in the specified subscription are dropped.
When sp_dropreplicateart is invoked with both a subscription name (sub_name) and replicate article name (rep_art) specified, the specified replicate article in the specified subscription is dropped.
To avoid problems on case-insensitive data servers,
always specify replicate object names using the same character case
as returned by the catalog stored procedures on the replicate data
server.
If any replicate articles subscribe to a primary article, you must drop the subscribing replicate article before you can drop the primary article from the associated publication.
When the requested action occurs successfully, no results are returned.
When an error occurs, an error message is returned.
sp_addreplicateart, sp_dropprimaryart, sp_dropsub, sp_helpreplicateart, sp_helpreplicateconn, sp_helpsub
| Copyright © 2005. Sybase Inc. All rights reserved. |
|
|
