Contents Index Publishing only some rows using a subscription expression Dropping publications

SQL Remote User's Guide
  SQL Remote Design for Adaptive Server Anywhere
    Publishing data

Altering existing publications


After you have created a publication, you can alter it 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.

You can perform these tasks using Sybase Central or with the ALTER PUBLICATION statement in Interactive SQL.

To modify the properties of existing publications or articles (Sybase Central)

  1. Connect to the database as a user who owns the publication or as a user with DBA authority.

  2. Right-click the publication or article and choose Properties from the popup menu.

  3. Configure the desired properties.

To add articles (Sybase Central)

  1. Connect to the database as a user who owns the publication or as a user with DBA authority.

  2. In the left pane, open the Publications folder.

  3. Select the publication you want to add an article to.

  4. From the File menu, choose New > Article.

    The Article Creation wizard appears.

  5. In the Article Creation wizard, do the following:

  6. Click Finish to create the article.

To remove articles (Sybase Central)

  1. Connect to the database as a user who owns the publication or as a user with DBA authority.

  2. Open the Publications folder.

  3. Select the publication you want to remove an article from.

  4. Right-click the article you want to delete and choose Delete from the popup menu.

To modify an existing publication (SQL)

  1. Connect to the database as a user who owns the publication or as a user with DBA authority.

  2. Connect to a database with DBA authority.

  3. Execute an ALTER PUBLICATION statement.

Example 

See also


Contents Index Publishing only some rows using a subscription expression Dropping publications