Publishing only some columns in a table

You can create a publication that contains all the rows, but only some of the columns of a table from Sybase Central or by listing the columns in the CREATE PUBLICATION statement.

Note

  • If you create two publications that include the same table with different column subsets, then any user that subscribes to both publications is unable to synchronize.

  • An article must include all the primary key columns in the table.

To publish only some columns in a table (Sybase Central Admin mode)

  1. Connect to the remote database as a user with DBA authority using the SQL Anywhere plug-in.

  2. Open the Publications folder.

  3. Choose File » New » Publication.

  4. In the What Do You Want To Name The New Publication field, enter a name for the new publication. Click Next.

  5. Click Next.

  6. On the Available Tables list, select a table. Click Add.

  7. Click Next.

  8. In the Available Columns list, expand the list of available columns. Select a column and click Add.

  9. Click Finish.

To publish only some columns in a table (SQL)

  1. Connect to the remote database as a user with DBA authority.

  2. Execute a CREATE PUBLICATION statement that specifies the publication name and the table name. List the published columns in parenthesis following the table name.

    See CREATE PUBLICATION statement [MobiLink] [SQL Remote].

Example

The following statement creates a publication that publishes all rows of the id, company_name, and city columns of the customer table: 

CREATE PUBLICATION pub_customer (
 TABLE customer (id, company_name,
  city )
)
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1