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.

Prerequisites

There is an existing remote database and you have DBA authority to connect to that database.

Context and remarks

Note

  • If you create two publications that include the same table with different column subsets, then you may only create a synchronization subscription for one of them.

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

To publish only some columns in a table using the CREATE PUBLICATION statement, execute a CREATE PUBLICATION statement that specifies the publication name and the table name. List the published columns in parenthesis following the table name.

 Publish only some columns in a table (Sybase Central)

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

  2. Open the Publications folder.

  3. Click 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.

Results

The selected tables columns are published.

Next

None.

Example

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

CREATE PUBLICATION pub_customer (
 TABLE Customers (id, company_name,
  city )
)

 See also
Copyright © 2012, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.1