Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.1 » MobiLink - Client Administration » SQL Anywhere clients for MobiLink » SQL Anywhere clients » Publications


Publishing whole tables

The simplest publication you can make consists of a set of articles, each of which contains all the rows and columns in one table.


The tables to be published must already exist.

Context and remarks

A publication can also be created by executing a CREATE PUBLICATION statement that specifies the name of the new publication and the table you want to publish.

 Publish one or more entire tables (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 Finish.


A publication is created.




The following statement creates a publication that publishes the whole Customers table:

 TABLE Customers

The following statement creates a publication including all columns and rows in each of a set of tables from the SQL Anywhere sample database:

 TABLE Customers,
 TABLE SalesOrders,
 TABLE SalesOrderItems,
 TABLE Products

 See also