♦Thefollowing statement creates a publication that publishes the whole
customertable:
CREATE PUBLICATION pub_customer (
TABLE customer
)
♦Thefollowing statement creates a publication including all columns and
rowsin each of a set of tables from the Adaptive Server Anywhere
sampledatabase:
CREATE PUBLICATION sales (
TABLE customer,
TABLE sales_order,
TABLE sales_order_items,
TABLE product
)
☞Formore information, see the “CREATE PUBLICATION statement”
[ASASQL Reference, page 385].
Publishing only some columns in a table
Youcan 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
CREATEPUBLICATION statement.
❖Topublish only some columns in a table (Sybase Central)
1. Connect to the database as a user with DBA authority.
2. In the left pane, select the Publications folder.
3. From the File menu, choose New ➤Publication.
ThePublication Creation wizard appears.
4. Type a name for the new publication. Click Next.
5. On the Tables tab, select a table from the list of Available tables. Click
Add. The table is added to the list of Selected Tableson the right.
6. On the Columns tab, double-click the table’s icon to expand the list of
AvailableColumns. Select each column you want to publish and click
Add. The selected columns appear on the right in the Selected Columns
list.
7. ClickFinish.
94