ASA SQL Reference
  SQL Statements

ALTER PUBLICATION statement

Description 

Use this statement to alter a publication. In MobiLink, a publication identifies synchronized data in a Adaptive Server Anywhere remote database. In SQL Remote, publications identify replicated data in both consolidated and remote databases.

Syntax 

ALTER PUBLICATION [ owner.]publication-name alterpub-clause, ...

alterpub-clause:
  ADD TABLE article-description
| MODIFY TABLE article-description
| { DELETE | DROP } TABLE [ owner.]table-name
| RENAME publication-name

owner, publication-name, table-name : identifier

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

Usage 

This statement is applicable only to MobiLink and SQL Remote.

The ALTER PUBLICATION statement alters a 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.

You set options for a MobiLink publication with the ADD OPTION clause in the ALTER SYNCHRONIZATION SUBSCRIPTION statement or CREATE SYNCHRONIZATION SUBSCRIPTION statement.

Permissions 

Must have DBA authority, or be the 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

ALTER SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]

CREATE SYNCHRONIZATION SUBSCRIPTION statement [MobiLink]

sp_add_article procedure

sp_add_article_col procedure

Standards and compatibility 

• SQL/92    Vendor extension.

• SQL/99    Vendor extension.

Example 

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

ALTER PUBLICATION pub_contact
   ADD TABLE customer