You alter a publication by adding, modifying, or deleting articles, or by renaming the publication.
Altering publications in a running SQL Remote system can cause replication errors and a loss of data in the replication system. See Upgrading and resynchronization.
Connect to the database as a user who owns the publication or as a user with DBA authority.
In the left pane, select the Publications folder.
Right-click the article you want to alter and choose Properties to edit the publication.
Connect to the database as a user who owns the publication or as a user with DBA authority.
Execute an ALTER PUBLICATION statement.
For example, the following statement adds the Customers table to the PubContacts publication.
ALTER PUBLICATION PubContacts ( ADD TABLE Customers ); |
For example, the following statement redefines the Customers article in the PubContacts publication.
ALTER PUBLICATION PubContacts ( ALTER ARTICLE Customers ( name, surname ) ); |
Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |