User's Guide

Part VI. SQL Anywhere Reference

Chapter 43. Watcom-SQL Statements

Function

To alter the definition of a SQL Remote publication.

Syntax

     ALTER PUBLICATION [ owner.]publication-name
               ADD TABLE article-description
          ...    | MODIFY TABLE article-description
              | { DELETE | DROP } TABLE [ owner.]table-name
              | RENAME publication-name

Parameters

     article-description:
          table-name [ ( column-name, ... ) ]
          ...     [ WHERE search-condition ]
          ...     [ SUBSCRIBE BY expression ]

Usage

Anywhere. This statement is applicable only to SQL Remote.

Permissions

Must have DBA authority, or be owner of the publication. Requires exclusive access to all tables referred to in the statement.

Side effects

Automatic commit.

See also

• CREATE PUBLICATION statement
• DROP PUBLICATION statement

Description

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.

Example

The following statement adds the customer table to the pub_contact publication.

     ALTER PUBLICATION pub_contact (
         ADD TABLE customer
     )