Use the following procedures to create a publication that contains all the rows, but only some of the columns, of a table.
Use the SQL Anywhere 12 plug-in to connect to the consolidated database as a user with DBA authority.
In the left pane, expand the Publications folder.
Choose File » New » Publication.
In the What Do You Want To Name The New Publication field, type a name for the publication. Click Next.
On the Available Tables list, select a table. Click Add. Click Next.
On the Available Columns tab, double-click the table's icon to expand the list of Available Columns. Select each column you want to publish and click Add. Click Next.
Connect to the consolidated database as a user with DBA authority.
Execute a CREATE PUBLICATION statement that specifies the publication name and the table name. List the published columns in parentheses following the table name.
For example, the following statement creates a publication that publishes all the rows of the ID, CompanyName, and City columns of the Customers table. This publication does not publish the Surname, GivenName, Street, State, Country, PostalCode, and Phone columns of the Customers table.
CREATE PUBLICATION PubCustomers ( TABLE Customers ( ID, CompanyName, City ) );
Discuss this page in DocCommentXchange.
|Copyright © 2010, iAnywhere Solutions, Inc. - SQL Anywhere 12.0.0|