Data Replication with SQL Remote
PART 4. Reference
CHAPTER 17. Command Reference for Adaptive Server Anywhere
To alter the definition of a SQL Remote publication.
ALTER PUBLICATION [ owner.]publication-name
ADD TABLE article-description
... | MODIFY TABLE article-description
| { DELETE | DROP } TABLE [ owner.]table-name
| RENAME publication-name
article-description:
table-name [ ( column-name, ... ) ]
... [ WHERE search-condition ]
... [ SUBSCRIBE BY expression ]
Anywhere. This statement is applicable only to SQL Remote.
Must have DBA authority, or be owner of the publication. Requires exclusive access to all tables referred to in the statement.
Automatic commit.
The ALTER PUBLICATION statement alters a SQL Remote publication in the database. The contribution to a publication from one table is called an article. Changes can be made to a publication by adding, modifying, or deleting articles, or by renaming the publication. If an article is modified, the entire specification of the modified article must be entered.
The following statement adds the customer table to the pub_contact publication.
ALTER PUBLICATION pub_contact ( ADD TABLE customer )