The simplest publication you can make consists of a single article, which consists of all rows and columns of a table.
You can use either Sybase Central or Interactive SQL to perform this task.
In Sybase Central, you can perform this task while working with the connected database.
To publish one or more whole UltraLite tables (Sybase Central)
Connect to the UltraLite database.
Right-click the Publications folder, and choose New » Publication.
The Create Publication Wizard appears.
Type a name for the new publication, and click Next.
On the Tables tab, select a table from the Available Tables list. Click Add.
The table appears in Selected Tables on the right.
Optionally, you may add additional tables. The order of the tables is not important.
Click Finish.
In Interactive SQL, you can perform this task with the CREATE PUBLICATION statement.
To publish one or more whole UltraLite tables (Interactive SQL)
Connect to the UltraLite database.
Execute a CREATE PUBLICATION statement that specifies the name of the new publication and the table you want to publish.
For example, the following statement creates a publication that publishes the whole customer table:
CREATE PUBLICATION pub_customer ( TABLE customer ); |
| Send feedback about this page via email or DocCommentXchange | Copyright © 2008, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.0 |