SQL Remote User's Guide
Command Reference for Adaptive Server Enterprise
To change the description of an article in a procedure.
sp_modify_article
publication_name,
table_name,
[ where_expr, ]
[ subscribe_by_expr ]
[ subscribe_by_view ]
| 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. |
| subscribe_by_view |
A view defining the rows and columns to be included in the publication. The default is NULL.
For more information, see Tuning extraction performance and Tuning extraction performance for shared rows. |
To change the description of an article in a publication. The WHERE expression, the subscription expression, and the subscription view can each 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.
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