sp_modify_article procedure
Purpose Tochange the description of an article in a procedure.
Syntax sp_modify_article
publication_name,
table_name,
[where_expr, ]
[subscribe_by_expr ]
[subscribe_by_view ]
Argument Description
publication_name
Thename of the publication for which the article is to
bemodified.
table_name
Thetable containing the article.
where_expr
This optional argument must be a column name or
NULL.The publication includes only rows for which
thesupplied column name is not NULL.
Thedefault value is NULL, in which case no rows are
excludedfrom the publication..
subscribe_by_expr
The new subscription expression defining which
rows are to be included in the publication for each
subscription.
Thedefault value is NULL.
subscribe_by_view
Aview defining the rows and columns to be included
inthe publication. Thedefault is NULL.
Formore information, see “Tuning extraction perfor-
mance” on page 155 and “Tuningextraction perfor-
mancefor shared rows” on page 162.
Seealso “sp_add_articleprocedure” on page 381
“sp_remove_articleprocedure” on page 428
“ALTERPUBLICATIONstatement” [ASA SQL Reference, page 280]
Description Tochange the description of an article in a publication. The WHERE
expression,the subscription expression, and the subscription view can each
bechanged.
Aswith other data definition changes, in a production environment this
procedureshould only be run on a quiet SQL Remote installation.
398