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

sp_modify_article procedure

Purpose 

To change the description of an article in a procedure.

Syntax 

sp_modify_article

publication_name,

table_name,

[ where_expr, ]

[ subscribe_by_expr ]

Argument	Description
publication_name	The name of the publication for which the article is to be modified.
table_name	The table containing the article.
where_expr	This optional argument must be a column name or NULL. The publication includes only rows for which the supplied column name is not NULL. The default value is NULL, in which case no rows are excluded from the publication..
subscribe_by_expr	The new subscription expression defining which rows are to be included in the publication for each subscription. The default value is NULL.

See also 

sp_add_article procedure

sp_remove_article procedure

Description 

To change the description of an article in a publication. The WHERE expression and the subscription expression can both be changed.

As with other data definition changes, in a production environment this procedure should only be run on a quiet SQL Remote installation.

     For more information on the requirements for a quiet system, see Making schema changes.

Examples 

• The following statement changes an article in the SalesRepData publication that takes information from the Customer table, so that it has no subscription expression:

  sp_modify_article SalesRepData, Customer
  go

• The following statement changes an article in the SalesRepData publication that takes information from the Customer table, so that it has a subscription expression that is the rep_key column:

  sp_modify_article SalesRepData, 
     Customer,
     NULL,
     rep_key
  go