Sybase DC38133-01-0902-01 manual Dropping publications, To remove articles Sybase Central

♦Choose a table and click Next.

♦Choose the columns for the article. Click Next.

♦Enter a WHERE clause (if desired). Click Next.

♦Create a SUBSCRIBE BY restriction (if desired).

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	♦ The following statement adds the customer table to the pub_contact
	publication.
	ALTER PUBLICATION pub_contact (
	ADD TABLE customer
	)
	☞ See also
	♦ “ALTER PUBLICATION statement” [ASA SQL Reference, page 280]
	♦ “Publishing only some rows using a WHERE clause” on page 96
	♦ “Publishing only some rows using a subscription expression” on page 97

Dropping publications

You can drop a publication using either Sybase Central or the DROP PUBLICATION statement. If you drop a publication, all subscriptions to that publication are automatically deleted as well.

You must have DBA authority to drop a publication.

100