Modifying an existing publication using SQL

Articles and publications can be modified after they are created.

Prerequisites

There is an existing remote database and you have the SYS_REPLICATION_ADMIN_ROLE system role.

Publications can be altered only by the DBA or the publication's owner.

Results

The publication or article is modified.

Example

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

ALTER PUBLICATION pub_contact 
 ADD TABLE Customers