Alter publications

You alter a publication by adding, modifying, or deleting articles, or by renaming the publication.

Caution

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.

To alter a publication (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, select the Publications folder.

  3. Right-click the article you want to alter and choose Properties to edit the publication.

To alter a publication (SQL)
  1. Connect to the database as a user who owns the publication or as a user with DBA authority.

  2. 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 )
    );
See also